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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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...
 
Back
Top