Conditional Formating Cells With Formulas Based on Whether It is Blank Hi, I hav

Question

Conditional Formating Cells With Formulas Based on Whether It is Blank

Hi, I have a column that is populated with the formulas below. My goal is to conditionally format each cell when it has a value and not format it when the result of the cell formula is null. I tried a few approaches and have not been successful. Could someone please walk me through the process of how to do this? Secondly, please tell me how to copy the conditional formating down to every cell in the column. I really do appreciate your help. :)

Thanks !!

Selected Categories =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J1)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J2)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J3)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J4)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J5)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J6)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J7)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J8)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J9)),"") =IFERROR(CUBERANKEDMEMBER("PowerPivot Data",$AE$1,ROW(J10)),"")

Explanation / Answer

Hi..

Select all your cells that you want to format, choose the "Home" Tab, click the "Conditional Formatting" button, choose "New Rule..." CF and the "Use a formula to determine which cells to format" and use this formula in the "Format values where this formula is true" box

=D1<>""

replacing the D1 with the address of the activecell (the first cell of your selection). Click the Format... button to set your formatting. And click OK all the way out. And you're done...

Conditional formatting copies and pastes just like regular formatting - you just need to make sure that your formulas will update correctly if you are using formulas. That is why selecting all the cells and using one formula will work - we did not use $s in the cell address.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.