Hello,
Please take a look the attach sheet, I want cell G4 to turn yellow when it close to 30 days of anniversary and turn to red if it pass the anniversary date. if G4 have the date then it override and change to white.
I mean to say anniversary date is start date.
Thanks
Book1 test.xlsx
Using a formula
=$D4<NOW()-335
for yellow
and =$D4<NOW()-365
for Red.
Apply to =$G$4:$G$7
Martin
sorry, it did not work. Please see attach fileBook1 test.xlsx
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
sorry still did not work, May be I did not fill out the formula right
Book1 test.xlsx
Please see attachment
Did you look at my examples?
Yes i saw, but did not work the way i want. if there is date for dec month that also turn to red. I do not how I do this. I am working on employee review file, I want cell to change yellow when they are close to their review and turn red when they pass the date. but I am not sure how to do if the employee start date is like if they start in dec 2009. so their review is not due and not close to due but they also turn to red.
is there any macro that look for those dates and do the magic
You entered the wrong formula for RED:
="and =$D4<NOW()-365"
It should be
=$D4<NOW()-365
Ben Van Johnson
Thank you very much, but as I mention above, I do not how to with if I have date for Dec month that is not due or not to close and that turn to red as well
Please see the attachment. I am beginning to thing that you are looking for formatting which will give yellow and red each year rather than just for the first anniversary. The attachment has this formatting and has a larger set of dates to test it out.
Thank you very much for your time and help. I am very thankful.
Thank you once again
RR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks