Conditional Formatting

[geoffcraver]

Hello,

I would like to fill in a cell blue if the value in adjacent cell is 'True'. I can't figure out how to do it.

So how would I use fill color in H2 if L2 is 'true'?


Thanks

 

[Jonmo1]

Try using "Formula Is"
and for the formula, put
=L2

 

[VoG]

Try the CF formula

=L2

 

[geoffcraver]

Thanks. Does it matter if I have values in column H though? Right now I have the part number in column H. So if L2 is true, I want to highlight H2.


Thanks

 

[VoG]

Maybe

=AND(L2,H2<>"")