Hi Folks
I have a Conditional Formatting Issue in Excel 2010 that I am unable to resolve.
Basically I have three fairly basic rules on a column which are based on values in another column. The first rule works fine, but the other two dont. I have attached an example of my issue.
I have tried the Ctrl+Shift+Alt+F9 option which fixed the first conditional formatting rule but not the others.
Any help/advice would be appreciated.
Thanks in advance
Tony
Last edited by ARGK; 07-07-2014 at 09:26 AM.
Hi Tony,
Can't actually see any attachment
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard
Just corrected the attachment.
Thanks
Tony
where is your so called attached example..?
Say Thanks, Click *
Sort the rules in the reverse of how they are sorted now maybe
Not sure, the example sheet is trying to pull data from a D drive that doesn't exist on my computer!
Edit: I see the example sheet? Others don't? o.O
Get rid of the double quotes in the conditions. Instead of
e.g.
="AND(A6=0%,C6>NOW()-3)"
use
=AND(A6=0%,C6>NOW()-3)
Also, you'd be better of using TODAY() instead of NOW(), since you are just concerned with date and not time
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi
I have removed the links so you can see the data (sorry). I have also reversed the rules but to no avail.
Thanks
Tony
Hi Ace_XL
Many thanks. Your solution worked a treat. For some reason Excel puts the quotes in on my device!!!!
Tony
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks