Forum Discussion

Twiddy's avatar
Twiddy
Copper Contributor
Apr 05, 2024
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...
  • HansVogelaar's avatar
    Apr 05, 2024

    Twiddy 

    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.

Resources