Highlighting A Cell

C

Coltsfan

Does anyone know how to do a formula that says if a cell equals the wor
FALSE then highlight this particular cell gray?

Example:

Typing in Cell A2
IF A1 = FALSE then gray otherwise white

I tried to do it in Conditioning Formatting but can't figure it out t
reference another cell. Any help would be greatly appreciated
 
D

dominicb

Good evening Coltsfan

You're right in trying to use conditional formatting, the formula yo
would need to use in cell A2 is thus:

=A$1$=FALSE

Remember to set the drop down box to formula is. In this instance yo
do not put quotes around the word false, as this is a recognised Exce
flag, if you were using a different word (eg FALSE1) you would need t
enclose the keyword in quotes.

HTH

Dominic
 
Top