Conditional formatting

01/25/18 Edited 12/09/19

Hello, 

How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red?

 

Is that possible?

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    Yes, if you choose the formatting option in the toolbar you will be able to color the row or the cell based on the date column you choose being in the past. See screenshots below. 

    More on Conditional Formatting.

     

    2018-01-25_08-43-46.jpg

    2018-01-25_08-45-55.jpg

Sign In or Register to comment.