var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conditional Formatting Problem
In the attached spreadsheet I would like to have dates <today() be highlighted in red.
But all the dates are highlighting rather than just the ones that are less than today.
The column is formatted as a date and I'm using the conditional formatting tool but it's not working.
Take a peek at the attached and tell me what I'm doing wrong.
Total Equipment List.zip
take the quotes off the rule
cell value less than ="Today()" should be
cell value less than =Today()
Worked wonderfully, thanks.