Hi all,
Need help with the following conditional formatting.
I have a few conditions in the "status" column and where if the test is "closed" or if the cell is blank there will not be any colour change to the cell.
However if base on the date, if the recieved date is more than or equal to 30 the cell should be highlighted red. I'm unable to get the formula for it to work correctly, please refer to the sample excel provided.
Thanks a lot!
sample book.xlsx
Try this as the CF formula: =AND(TODAY()-A2>=30,OR(B2<>"",B2<>"Closed"))
------------------
Any good? Wave it, click on the little star at the bottom left of my responses
Last edited by Max, Singapore; 02-04-2014 at 04:39 AM.
hi there~ didn't hear from you since your last question on frequency. delete your existing rules & select B2:B205. use this formula:
=AND(B2<>"",B2<>"Closed",$E$1-A2>=30)
Last edited by benishiryo; 02-04-2014 at 04:58 AM. Reason: added file
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hey guys,
thanks for your reply, but doesnt seem to work for me when i enter it, is there a formula that would help without deleting the other 2 conditions? So that it would only be concern with calculation of the date only.
Hey ben! sorry totally forgot about that thread, was too busy with work.
Hey guys really thank you for all your suggestions and help i seem to have found the solution, i replaced the forumla with =TODAY()-A2:A213>=30 and it worked alright.
Thanks again, appreciate it and Happy Chinese New Year to all! HUAT AH!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks