Color Formatting

[Rick Brown]

Excel97
If any cell in column A has a "X" typed into it, how can I highlite in
Yellow the five adjacent cells in that row?

Thanks, Rick

 

[Jake Marx]

Hi Rick,

If any cell in column A has a "X" typed into it, how can I highlite in
Yellow the five adjacent cells in that row?

You can do this with Conditional Formatting:

1) select your range to be formatted (in this case, let's say B1:F9)
2) select Format | Conditional Formatting
3) select Formula Is from the dropdown
4) type =$A1="X" in the textbox
5) click the Format button and set the pattern to yellow
6) click OK

This is dynamic, so if you type a X into any cell in A1:A9, the 5 cells to
the right of that cell will be highlighted in yellow.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]