Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to format a cell so that if a value is greater than 5 the cell
will be coloured Red, if it is between 2 and 4 it will be Orange and if it is between zero and 1 it will be Green, how do I do it? I tried to use the IF function but it didn't seem to work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |