| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with Conditional Formatting and Greater than or equal too
When you say exactly 1, do you mean exactly 0.1?
Secondly, are you sure that the number is indeed exactly that? How many decimal places are you displaying? If you've got a rounding inaccuracy, you may want to use the ROUND function. -- David Biddulph "Amanda" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
