Conditional Formatting with Specific Text

[fben96]

Hi, I am trying to conditionally format a large amount of cells. These cells have these formulas in them.

=IFERROR(IF(VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))=0,"Incomplete WO",VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))), "No Record")

I would like for the cells to change color when "Incomplete WO" populates the cell. And for it to change a different color when, "No Record" populates the cell. I have tried specific text containing ="...." but it isn't working.

 

[Fluff]

Select the cells you want to highlight > In CF > New Rule > Use a formula > =$A1="Incomplete WO" > select format > OK
and repeat for other values.

The $A1 needs to match the first cell in the Applies to range

 

[Nine Zero]

in the formula for the condition you also have to specify the cell

for example... .lets say all your formulas are in column X starting in the second row

in your conditional formatting formulas put

=$X2="Incomplete WO"

then add another condition for the other case

=$X2="No Record"

and set your colors

 

[fben96]

Is there an easier way. I have over 150 cells, that would be 150 rules. Thank you!

 

[Nine Zero]

it will automatically apply to the entire column

which is why we only make the column Absolute and not the row number

$X2

 

[fben96]

The only Problem is my cells are not all in the same column.

 

[Fluff]

In that case simply remove the $ sign

 

[fben96]

Got it. Thank you!!

 

[Fluff]

Glad we could help & thanks for the feedback