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

[Guest]

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?

 

[Guest]

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.

HTH,
Elkar

 

[Guest]

Perfect! Thanks.

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.

HTH,
Elkar