Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have spreadsheet that has conditions and depending on those conditons the
cells changed color. For example: if cell is less than .29 or = to .29 turn the cell red. Now this cell that has the actual number is next to the cell that shows the % and then the color and the conditional cell has a formula in it. =B12/$B$10. Example: Cell B12 =54 and cell B10 has a total formula thus giving me the number 39. How can I put a formula in the cell that already has the =B12/$B$10 that will round the number up say from .46 to .05 thus updating my color? See right now it does not change to the next color even though I decrease the decimal point. I want to round up in the condional formatting. Help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Formula | Excel Worksheet Functions | |||
Conditional Formatting Formula | Excel Worksheet Functions | |||
what formula do I use for conditional formatting? | Excel Worksheet Functions | |||
Conditional Formatting Formula | Excel Worksheet Functions | |||
conditional formatting or formula | Excel Worksheet Functions |