Conditional Formatting Help

Occasional Visitor

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


You have to create a separate rule for each condition.