Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Formatting
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Formatting
Hi Rick,
Rick Brown wrote: 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] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color formatting | Excel Worksheet Functions | |||
Conditional Formatting on Color | Excel Worksheet Functions | |||
Color Formatting | Excel Discussion (Misc queries) | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Formatting Color into cells | Excel Discussion (Misc queries) |