Explore. Ask. Answer.

or Explore Discussions

Conditional formatting

agetchius35541agetchius35541
edited 12/09/19 in Formulas and Functions
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?

Popular Tags:

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.