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

J

janet686

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?
 
E

Elkar

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
 
J

janet686

Perfect! Thanks.

Elkar said:
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
Click to expand...
 
Top