| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format of range
Data is input in to cell E57.
A percentage is calculated, based on the input and returned to cell E58. I used CF to compare this with cell E29 =$E$58$E$29 If the result is above that of E29, E58 turns red. What I want to do is turn E58 yellow if the result is up to 10 below E29. What I mean is if cell E29 = 100 E58 100 turn red E58 is 90 to 99 turn yellow E58 < 90 no format |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format over Date Range | Excel Discussion (Misc queries) | |||
| How can I conditional format using a range of numbers | Excel Discussion (Misc queries) | |||
| conditional format a range | Excel Discussion (Misc queries) | |||
| Conditional Format based on range | Excel Discussion (Misc queries) | |||
| Conditional format IP range | Excel Discussion (Misc queries) | |||
Threaded Mode
