| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting.
I have one cell that will change percentage based on calculations from two
other cells. I also have a row with ranges that I need to change color is the first cell is in that range is meet. if D1 = 97.75% then I want E2 to highlight. Any Ideas? D1 E1 - E6 100% 100 % 99.99% to 97.50% 97.49% to 95.00% 94.99% to 92.50% 92.49% to 90.00% 89.99% to 87.50% 87.49% to 85.00% 84.99% to 82.50% 3.00% $25.50 $25.50 82.49% or Less 2.00% $17.00 $17.00 -- We all need a little help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
