Highlight entire row if error found

[richarddec]

If columns AA:AD are equal to TRUE, can the entire row that contains the "TRUE" be highlighted?

 

[Scott Huish]

This assumes starting at row 1, adjust as necessary:

Select all the columns you want highlighted
Click on Format, then Conditional Formatting
Under Condition 1, change Cell Value is to Formula Is and put in the following formula:
=AND($AA1:$AD1)
Click on Format
Click on Patterns
Select a Color
Click OK
Click OK

 

[richarddec]

The trick of it is that if a cell in COLUMN AA to AD have a TRUE in it, I want the whole row of the true item to be highlighted.

 

[Scott Huish]

I want the whole row of the true item to be highlighted.

Yes, that is why I said select all the columns you wanted to highlight, so if your row goes from column A to AD, select all those columns, and do like I said above.


a text TRUE or a value TRUE?

All 4 cells or any?

If it's any and a value TRUE

just change the formula to:
=OR($AA1:$AD1)

 

[richarddec]

Ahh I see. I used the OR formula and its doing great. Thanks a bunch. Hopefully one day I will know these things as good as many of the people here do.

One day... mark my words!! *shakes fist*