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

1

Coda
Coda549×691 16.3 KB

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.

2

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:

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

Then set up conditional format on this checkbox column

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

3 Likes
3

Thank You so much. Its working perfectly

4

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