| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Conditional Formatting and Greater than or equal too
I am comparing 2 percentages.....B5 & B6. In Cell C6, I have calculated the
difference. Based on that number, I want B6 color coded. I am using conditional formatting. If greater than or equal to .01, green. If less than -.01 red....all other yellow. My problem is that if the difference is exactly one, it is not changing it to green. Am I missing something? I have greater than or equal to in the conditional formula. As always thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on an equal value in another workshee | New Users to Excel | |||
| IF with Equal to or Greater than | Excel Discussion (Misc queries) | |||
| Greater than or equal to (Plus or minus) | Excel Discussion (Misc queries) | |||
| First occurance greater than or equal to a specified value | Excel Worksheet Functions | |||
| GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct | Excel Worksheet Functions | |||
Threaded Mode
