 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Problem 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. 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.  SignatureDavid Biddulph >I am comparing 2 percentages.....B5 & B6. In Cell C6, I have calculated >the [quoted text clipped - 7 lines] > > As always thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.