Conditional FormattingI

Options
PeggyLang
PeggyLang ✭✭✭✭✭

I have a column of dates with conditional formatting that turns the cell Red if the date does not fall on a Monday. This works fine.

If the date is longer than 7 days in the past then I don't want the cell Red.

I have a helper column that returns a '1' if the date in the cell is more than 7 days old.

Now I want to add another conditional format that says 'if helper column = 1, then no cell background'.

Response from Smartsheet is


I can't figure this out.

Best Answer

Answers