Thread: How do I format one cell based on contents in another cell in Exce
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default 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?

Reply With QuoteReply With Quote