Dec 14 2021 12:50 PM
Hi there! I am trying to figure out if it's to cancel a formula written in conditional formatting when another cell has text.
The conditional formatting is for a cell to change fill color if the date inputted is past a certain time; this is the formula: =AND(TODAY()-G2>=10, TODAY()-G2<=13).
I need to cancel this formula if the next column cells have any text, but also keep the text in both cells.
Thanks in advance for the help!
Dec 14 2021 01:11 PM
Perhaps
=AND(TODAY()-G2>=10, TODAY()-G2<=13, H2="")
or if you want to look at more columns, for example H through K:
=AND(TODAY()-G2>=10, TODAY()-G2<=13, H2:K2="")
Dec 14 2021 01:21 PM
Dec 14 2021 01:36 PM
Dec 14 2021 01:49 PM