Forum Discussion
Conditional Formatting for dates
I have a spreadsheet with names going down on the left side column, at the top going right in the columns I have courses people have taken. In each intersecting cell there is the date of expiry for t...
Sorry I jump in, just small comment to
1) in the formula box you type = [condition] and if that [condition] evaluates to be true the formatting will be applied. if false it will not.
More exactly trigger works on TRUE (or it's numeric equivalent) and doesn't work on any other value (FALSE, text, error). In addition, if several rules are applied to the same cell/range, condition only in first in sequence rule triggers the formatting for this cell/range.
I couldn't explain it better ... thank you 🙂