I am trying to create an IF formula that is based on how long someone is out of date. I would like cells B and C to fill to red if out of date for a year or more and orange if 6 months to 1 year. Currently I am using conditional formatting "format cells that contain" =NOW()-365 for red and =NOW()-186 for orange, the problem is it is only on the selected cells, C. How can I do this to make both B and C fill vice just C? Please see attachment. Thank you!
Last edited by MAI2010; 08-20-2013 at 05:31 PM.
I think you have provide this forum with a workbook with data for better understanding.
I would like the name column to change color with date column when the criteria is met. Currently only the date column changes. I have attached a updated workbook. Any suggestions?
something like this
Yes, but when I use the spreadsheet you attached it does not change the cell fill at all.
update of the file
Remove all CF rules and start again.
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =YEAR(TODAY())-YEAR($C35)>0 format fill RED
repeat 3 & 4 change to =TODAY()-$C35>182.5
Make sure the 1st formula is 1st in the list
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks