Assume the first cell address in the top left hand corner is cell A1. Cells A1:C8 are all dates, formatted differently (columns 1&2 are seperate of column 3). I need to format cell C to be flagged with red font or a red background when the date in cell C is less then 2 weeks away from the date in columns 1 or 2. This has to be coupled with the condition that column K is "Yes". Is this possible?
If not, is it possible to shift all cells right, and create a blank column A and enter a formula here where this cell will then be flagged if it meets above conditions?
I.e. Take a look at Row 4. 32411 means March 24th, 2011. Being that 1-Apr-11 in column C is less then 2 weeks away from March 24th, 2011 and K4 is flagged "Yes", is it possible to enter a condition that will flag this?! Hopefully this makes sense. Thanks in advance!
Bookmarks