Forum Discussion
Solved
Dates not matching with formula and conditional formatting
Hello. I am having real difficulty with conditional formatting for dates. I am trying to highlight dates that fall on a weekend or a bank holiday. But for some reason the conditional formatting...
You have selected entire rows for the "Apply to" range.
A row begins in column A, so your formulas should refer to A$2 instead of B$2.
You have selected entire rows for the "Apply to" range.
A row begins in column A, so your formulas should refer to A$2 instead of B$2.
Awesome. That has worked, thank you!!