Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - another cell
How exactly is this done?
I am trying to format a cell (A20) if cell (B20) is within ranges <0 = red 0-5 = orange 5 = green I am trying to do this across 75 values and I don't want to go in & program each cell independently. That would take forever. I have seen some information on "Formula Is" but that appears to be an Excel 2003 feature and I've been unable to find the right way to do this in Excel 2007. Help!!!!!?!?!?!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - another cell
I am trying to do this across 75 values
I don't know what that means. Here's how you can do this: I am trying to format a cell (A20) if cell (B20) is within ranges <0 = red 0-5 = orange 5 = green Select cell A20 Goto Home tabStylesConditional FormattingManage Rules Click New RuleUse a formula to determine... Format values where this formula is true: =B20<0 Click the Format button Select the desired style(s) OKOK Click New Rule again and repeat the above proccess for the second and third conditions. Use these formulas: Condition2: =AND(ISNUMBER(B20),B20=0,B20<=5) Condition3: =AND(ISNUMBER(B20),B205) Then, after you've set the third condition format: OKOKApplyOK -- Biff Microsoft Excel MVP "CT" wrote in message ... How exactly is this done? I am trying to format a cell (A20) if cell (B20) is within ranges <0 = red 0-5 = orange 5 = green I am trying to do this across 75 values and I don't want to go in & program each cell independently. That would take forever. I have seen some information on "Formula Is" but that appears to be an Excel 2003 feature and I've been unable to find the right way to do this in Excel 2007. Help!!!!!?!?!?!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format cell | Excel Discussion (Misc queries) | |||
Conditional format cell for $0 | Excel Worksheet Functions | |||
Conditional Format Row when Value Changes in One Cell | Excel Worksheet Functions | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Format of one cell conditional on another | Excel Worksheet Functions |