Hello there!

I'm working on writing some macros to process a tracker comparison, and need to establish conditional formatting based on a comparison (of text or date range) in the preceding cell. Can anyone please assist with the necessary Conditional Formatting formulas for these 5 comparison scenarios?

A B
1 data1 data1

2 (blank) data1

3 data1 data2

4 (blank) DATE7daysold

5 (blank) DATE<7daysold


Note: On my spreadsheet, 'data1' and 'data2' may be text or dates. They will always be the same type in respective rows. (comparing text to text, or date to date. Not comparing text to date.)


A1 and B1: data matches, nothing has changed. No cell shading

A2 and B2: no match (new data) shade B-cell PINK to indicate a revision or reforecast

A3 and B3: no match (updated data) shade B-cell PINK to indicate a revision or reforecast

A4 and B4: shade B-cell GREY to indicate a completion older than 7 days

A5 and B5: shade B-cell BLUE to indicate a completion within in the last 7 days

Thank you kindly for your assistance!