Hi All,
I have used conditional formating to a few cells as if its =0 turn green otherwise it stays red as the cell colour, but some cells do not change.
D22,G22,J22,M22,P22,Z22 the conditional formating doesn't work but S22,V22 and D45,G45,J45,M45,P45,Z45,S45,V45 and the cells 46 works.
Why does it not work?
See atatched
Will you please attach a sample Excel workbook?
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
see attached
Increase the number of decimal places in those cells that are not playing ball and you will see that they are not exactly 0. You will need to adjust your CF rule to account for what looks like a rounding error in columns where there are any values to be summed that are >0.
Try changing the rule to less than 0.01.
Thanks for your reply. As its a sum I would like it to turn red if its less than 0 or greater than 0, so will just less than 0.01 work?
Thanks
No - you will probably need to tell it to turn it green if it's between 0.01 and -0.01.
Thanks for your prompt reply.I am so sorry to bother you but its not working it turns green when the difference is 0.01 but red when its -0.01.
How exactly have you set up the rule? Maybe attach a new version of the file?
Please see attached
Try 0.001 and -0.001 instead.
Thanks its worked
No worries.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks