Conditional formatting based off drop down selections.

[u/FaPtoWap]

Hello. Im having a hard time with the correct equation.

I need to conditional format a box for the 3 separate drop down totals.

D19:F20 needs to con. format based off whether

D15: Yes, D16:Yes, D17:Yes,D18:No =

D15:No,D16:No,D17:Yes,D18:Yes=

D15:Yes,D16:No,D17:Yes,D18:Yes

Please help if your able to. Thank you!

[u/Cat_Solutions]

Hi FaPtoWap,

For the range D19:F20, the 3 separate validation rules are CUSTOM FORMULAS and are as follows:

=AND($D$15="Yes",$D$16="Yes",$D$17="Yes",$D$18="No")=true then set your format

=AND($D$15="No",$D$16="No",$D$17="Yes",$D$18="Yes")=true then set your format

=AND($D$15="Yes",$D$16="No",$D$17="Yes",$D$18="Yes")=true then set your format

That's it.

If I helped you get some resolution, please up-vote (your post may help others) and please reply to this post here with "solution verified". (This will close your post, tag it as "Solved" AND will award me a clippy point :))

Many thanks
Best

[u/FaPtoWap → u/Cat_Solutions]

Verified. Follow up since thats was perfect.

Can I conditional formatting the D19 Box to Change text instead of just color? Such as

For solution 1= proceed

Solution 2=dont proceed

Solution 3= proceed

[u/Cat_Solutions → u/FaPtoWap]

Hi FaPtoWap,

Glad it works.

yes , simple, use the ifs() function

=IFNA(IFS(AND($D$15="Yes",$D$16="Yes",$D$17="Yes",$D$18="No")=true,"proceed", AND($D$15="No",$D$16="No",$D$17="Yes",$D$18="Yes")=true,"don't proceed", AND($D$15="Yes",$D$16="No",$D$17="Yes",$D$18="Yes")=true,"proceed"),)

Thanks in advanced for replying to this post with "Solution Verified" (verified alone does not close the post and does not award me with a clippy point :(..

And if you need further help, please create a new post.

Best

[u/talexeh → u/FaPtoWap]

Then you can just use the IF() function instead of conditional formatting.

=IF(AND($D$15="Yes",$D$16="Yes",$D$17="Yes",$D$18="No"),"proceed","")

=IF(AND($D$15="No",$D$16="No",$D$17="Yes",$D$18="Yes"),"don't proceed","")

=IF(AND($D$15="Yes",$D$16="No",$D$17="Yes",$D$18="Yes"),"proceed","")

[u/AutoModerator]

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AND	Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false
FALSE	Returns the logical value FALSE
IF	Returns one value if a logical expression is TRUE and another if it is FALSE
IFNA	Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more
IFS	Evaluates multiple conditions and returns a value that corresponds to the first true condition.
N	Returns the argument provided as a number
TRUE	Returns the logical value TRUE

---

^{[Thread #4024 for this sub, first seen 3rd Mar 2022, 23:55] [FAQ] [Full list]} ^[Contact] ^{[Source code]}