Conditional Formatting Help

Copper Contributor

I am working on a vacation tracker spreadsheet where I want to conditionally format the cells.

 

I want a cell to change colors when a value greater than 0 is entered and the color is a light red if before today's date and a light green when it is after today's date.  Basically multiple conditions. I think it is possible but I can seem to figure it out. 

 

I figured out the first part of it where the color changes when a value is entered greater than 0 but the rest alludes me.

 

thank you

1 Reply

@jbillings12 

You have to create a separate rule for each condition.

S1014.png