| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting with decimals
I have a milestone number calculated for someone to meet, the number is 9.012, I am displaying it as 9 on the sheet. I have a conditional format of "if cell A1 is less than cell A2 (9.012) then RED"; then the second format is "if A1 is equal to or greater than A2 then GREEN". Well if my cell A1 is 9 it will stay red because it is less than A2, 9.012. I haven't used a formula because I don't know how. I am in the learning mode, how can I fix this problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Omitting the whole number when formatting decimals | Excel Discussion (Misc queries) | |||
| Omitting whole numbers when formatting decimals | Excel Worksheet Functions | |||
| Formatting axis decimals | Charts and Charting in Excel | |||
| Problem formatting decimals in ComboBox | Excel Programming | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Threaded Mode
