Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal format A2 using value in another cell C2
Using MS office 2007.
How to conditional format cell A2 basing on the value of the cell C2. The color fill is white if the value of the cell C2 is "ongoing" and red if the value is "completed". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal format A2 using value in another cell C2
1. Select the cell A2.
2. Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. =C2="completed" 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Joe" wrote: Using MS office 2007. How to conditional format cell A2 basing on the value of the cell C2. The color fill is white if the value of the cell C2 is "ongoing" and red if the value is "completed". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format | Excel Discussion (Misc queries) | |||
Conditonal Format | Excel Discussion (Misc queries) | |||
Conditonal Format Problem | Excel Discussion (Misc queries) | |||
Conditonal Format Formula | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) |