Formula for Conditional Formatting

[turpink]

Hi All,

looking for some help in regards to conditional formatting. Currently, I have a workbook that lists dates (Columns A & B will always be the same date, let's call them Date of Commitment, Column C's value differs in respect to the dates that occupy the cell addresses, it can be referred to as the Funding Date). If and when Column AG is flagged "Yes" and the date in column C is within 14 days of the respective row in Column B, I would like the cell in column C to be flagged. Is there any way to do this? Hopefully this is spelt out easily enough. Please see attached for a visual. Thanks in advance.

[tigeravatar]

turpink,

Attached is a modified version of your sample workbook. I applied the following formula to column C for conditional formatting:
=AND(AG1="Yes",C1-B1<=14)

Hope that helps,
~tigeravatar

[turpink]

Thanks so much