Oct 10 2019 02:13 PM
I have tried many different ways to get a range of cells to be formatted in a certain way based on a specific value not occurring in a different range of cells. I want the the cells in a specific range to look one way if the value "T" is NOT in a range of cells and look another way if any of the cells in that same range do equal "T." This seems pretty basic but I've tried various things and nothing works! For example:
=$N$14:$AB$14="T"
in one rule and
=$N$14:$AB$14<>"T"
in another rule
with different formatting rules to apply
Oct 11 2019 12:28 AM
Oct 11 2019 02:04 AM
You can make a New Rule using the formula given below...
=COUNTIF($N$14:$AB$14,"T")>0
The above formula will return True and apply the set conditional formatting if a 'T' is found in the range $N$14:$AB$14 else it will return False.
If you have to set the conditional formatting when there is no 'T' in the range $N$14:$AB$14, you may use the formula...
=COUNTIF($N$14:$AB$14,"T")=0
Oct 11 2019 06:08 AM
That works. Thank you very much.
Oct 11 2019 06:09 AM
Thank you @PascalKTeam for the suggestion.
Oct 11 2019 06:50 AM
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution which resolved your question as a Best Response/Answer to mark your question as Solved.