Hallo,
A1 cell and B1 cell are in data format. B1 cell contains a simple formula - "=A1+30" as for one month ahead.
What I want is when this date comes the cell (or up to ten cells in the same row nex to each other, if possible) to appear different colour. Red for example. I'm attaching an example.
Thank You
Select your range (i.e A3:G50) and go to conditional formatting>New Rule> Use formula ...
=MAX($A3:$G3)<= TODAY()
Format red
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank You Man. It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks