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.