Conditional format to give Background color to two consecutive days after the day which Checked

Please help…

I need 2 rest days after Workout (I need Meditation on those days). Need a conditional format so that it give “Red” background on 18/05/2022 and 19/05/2022 if I checked 17/05/2022.

Add a checkbox column Rest day and make a formula that will detect whether the previous or before previous day is a workout day. One way to do this is this:

  (CurrentValue.Day = thisRow.Day - 2 OR CurrentValue.Day = thisRow.Day - 1)
  AND CurrentValue.Workout

Then set up conditional format on this checkbox column

P.S. Welcome to the Community, @Amal_Raj!


Thank You so much. Its working perfectly

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.