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

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?

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

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


"janet686" wrote:

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?

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

Perfect! Thanks.

"Elkar" wrote:

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


"janet686" wrote:

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?