Excel - How do I format one cell based on contents in another cell in Exce

Asked By janet68 on 13-Apr-07 01:02 PM
I want to shade a number of cells based on the contents of a single cell.
For example: Cell A1 = ABCD.  I want cells A2, A3 and A4 to be shaded gray if
A1 does not equal ABCD.  Can this be done?

Elka replied on 13-Apr-07 01:12 PM
Select cells A2, A3 and A4
From the Format Menu, choose "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =$A$1<>"ABCD"
Click the "Format" button and select your format (grey background)
Click OK
Click OK

That should do it.

janet68 replied on 13-Apr-07 01:20 PM
Perfect!  Thanks.