Apr 06 2021 06:33 AM
I am trying to create a spreadsheet to highlight cells in A2 based on text of Yes or No (drop down box), based on all cells C2:K2. I have ready many articles and websites with many formulas to try, but they all are based on text in one cell.
Apr 06 2021 06:52 AM
SolutionYou may create New Rules for conditional formatting using the formulas given below for each scenario and set the format as per your choice.
For all the Yes in the Range C2:K2:
=COUNTIF($C2:$K2,"Yes")=COLUMNS($C2:$K2)
If any cell in the Range C2:K2 does not contains a Yes in it:
=COUNTIF($C2:$K2,"Yes")<>COLUMNS($C2:$K2)
Apr 06 2021 06:54 AM
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.
* Knowing the Excel version and operating system would also be an advantage.
Finally, please consider why does one of the helpers still have to prepare the file with your request?
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Apr 06 2021 07:05 AM
Apr 06 2021 07:06 AM
You're welcome @John7124! Glad it worked as desired.
Apr 06 2021 06:52 AM
SolutionYou may create New Rules for conditional formatting using the formulas given below for each scenario and set the format as per your choice.
For all the Yes in the Range C2:K2:
=COUNTIF($C2:$K2,"Yes")=COLUMNS($C2:$K2)
If any cell in the Range C2:K2 does not contains a Yes in it:
=COUNTIF($C2:$K2,"Yes")<>COLUMNS($C2:$K2)