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!!!!!?!?!?!! |
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 |