Hi all!
Long-time lurker on this forum - I've pretty much always been able to find an answer to a problem as someone else has asked before but can't quite find a solution to this one that works for me.
I have a series of dates in column A (representing when an assessment was carried out). In column B there are dates for 3 month reviews. In column C there are dates for 6 month reviews.
What I would like to happen is that the date is entered in A1 and when 90 days pass B1 turns red, and when 180 days pass C1 turns red. When a date is entered in either B1 or C1 I would like it to return to white.
I can get the conditional formatting to work on A1 itself, but I can't get the format to work for B1 and C1 based on the value in A1.
In A1 I have used: Cell value is less than =NOW()-90 to format A1 red when the date is over 90 days ago which works fine.
In B1 I have tried various versions of: Formula is =$A1=NOW()-90 but I just can't get it to work. I've had quotation marks, dollar signs and perenthises in just aout every possible combination but can't get one that works. I feel like it should be so simple and I'm missing something obvious!
Can anyone tell me if what i'm trying to do is possible or not and how to do it?
Thanks very much in advance!
Edit - apologies for atrocious spelling in thread title!
Long-time lurker on this forum - I've pretty much always been able to find an answer to a problem as someone else has asked before but can't quite find a solution to this one that works for me.
I have a series of dates in column A (representing when an assessment was carried out). In column B there are dates for 3 month reviews. In column C there are dates for 6 month reviews.
What I would like to happen is that the date is entered in A1 and when 90 days pass B1 turns red, and when 180 days pass C1 turns red. When a date is entered in either B1 or C1 I would like it to return to white.
I can get the conditional formatting to work on A1 itself, but I can't get the format to work for B1 and C1 based on the value in A1.
In A1 I have used: Cell value is less than =NOW()-90 to format A1 red when the date is over 90 days ago which works fine.
In B1 I have tried various versions of: Formula is =$A1=NOW()-90 but I just can't get it to work. I've had quotation marks, dollar signs and perenthises in just aout every possible combination but can't get one that works. I feel like it should be so simple and I'm missing something obvious!
Can anyone tell me if what i'm trying to do is possible or not and how to do it?
Thanks very much in advance!
Edit - apologies for atrocious spelling in thread title!
Last edited: