Forum Discussion

OliveW93's avatar
OliveW93
Copper Contributor
Mar 14, 2023

Changing a different cell colour depending on date

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

excel

9 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 14, 2023

    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?

    • lmerrick71's avatar
      lmerrick71
      Copper Contributor
      May 25, 2023

      I am working on an excel document and would like to use the traffic light system an example a supervision was due April and it hasn't take place it would turn to red automatically, if one was due today it would be green but would turn yellow next week if it hadn't taken place

       

       

Resources