0

Coloring tables or cells based on formulas

My apologies of this is a simple question. I'm not too familiar with the platform but would like to color columns based on formulas.

 

Currently, I have a "Lead Market Delivery Column which contains a date.

I would like to color the cells red and turn the text white for cells who's dates are greater today's date.

Unsure how to write it or where this should be added.

 

My formula (as a test) looks like this currently:

 

If ('Lead Market Current Delivery' > today, styled('Lead Market Current Delivery', "red", ""), "")

 

A big thanks in advance to anyone who can help.

Kind regards,

Sean.

Reply

null

Content aside

  • 3 yrs agoLast active
  • 573Views