Mar 02 2021 12:25 PM
I set up conditional formatting on a date field, column D, highlighting this week and next week. What I would like to do remove the conditional formatting from rows if it has a value in column Q? Can this be done?
Mar 02 2021 12:52 PM
Select the dates in column D. I'll assume that D2 is the active cell in the selection.
Remove the current conditional formatting rule(s).
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Usea formula to determine wich cells to format'.
Enter the formula
=AND(Q2="",D2>TODAY()-WEEKDAY(TODAY()),D2<=TODAY()-WEEKDAY(TODAY())+14)
Click Format...
Specify the desired formatting in the Font and Fill tabs.
Click OK, then click OK again.
Mar 04 2021 02:41 PM
@Hans Vogelaar Thank you for the help!
I have a new one, I think it is countifs?
I need to total column R if it says "Feb 21" and Column Q if it say "Yes"
I cant seem to get this to total? Any suggestions? THANK YOU!
Mar 04 2021 03:40 PM
Mar 05 2021 06:17 AM