Forum Discussion

Daniel Cook's avatar
Daniel Cook
Copper Contributor
Aug 24, 2017
Solved

How do I make excel change the colour of a cell depending on a different cells date?

Hi,

 

How do I make excel change the colour of a cell depending on a different cells date?

 

Turn A2 red if - E2 cell is smaller than todays date

Turn A2 yellow with red outline if - E2 cell is equal to todays date

Turn A2 clear if - E2 cell is bigger than the current date

 

  • tmcmahon71 

    Let's say you want to highlight a row if column F contains "Closed".

    Use the formula

     

    =$F2="Closed"

     

    If you want something different, please provide more detailed information.

Resources