Changing a different cell colour depending on date

Occasional Visitor

I am creating a spreadsheet with Clients info. I have their information stored in Excel but want to make their name cell change colour when I have a meeting with them on a specific date.

 

I have tried a few different formulas & rules, none of them are working quite right though. I'm almost there I just can't quite get it.

 

Example: 

I have Jane Doe's email, phone, and date of first contact as regular cells.

I meet with Jane on a date in the future & now need to input that date in her row of info - how can that date make her name change colour, whilst remaining clear without that date? I have an ! in the date cell until the meeting date is input, as it correlates to another formula, is that what's throwing the calculation off?

 

This rule needs to be applied to the whole column. I can get it working for just one cell but as soon as I add other cells, it stops working properly. 

 

I am confident in Excel but still not well versed so please use simple language. I hope this makes sense. I am using a 2019 version.

Many thanks

1 Reply

@OliveW93 

Could you post a screenshot of your worksheet (without real names and data)?

Or even better, attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?