Forum Discussion

jojo750's avatar
jojo750
Copper Contributor
Apr 15, 2023

Conditional Formatting Issue

Hi all,

 

First time post, I am trying to complete a conditional formatting task for the following;

 

Due date column (which is calculated from a previous cell) but want to colour code as follows;

 

Red - if date is today or before 

Yellow - if date is tomorrow and 30 days after 

Green - if date is 31 + days after

 

Can anyone help please.

 

Thanks  Jo