Create Conditional Formatting Rules Using Formals that Refer to Date Values

Create Conditional Formatting Rules Using Formals that Refer to Date Values

Six Minutes. Smarter.

10 месяцев назад

118 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@katiebond2617
@katiebond2617 - 27.02.2024 03:04

Hi! New subscriber. What I'm looking the internet for is, how can I highlight a cell if the checkbox it's linked to is "False" after a certain date? If the context helps I have a table that has each month as a row, and each cell in that row has a review for an employee that's due in that month. (For example in the January row it may have 1 cell that has Sally, another cell that has John, etc.)

If Sally's review didn't get completed in January when it's due (the box is linked to a checkbox), then I want conditional formatting to highlight Sally's cell if the box isn't checked by February 1st.

I hope this makes sense!!

Ответить