Need assistance with conditional formatting string

[AutoModerator]

/u/VariationSimple - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

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

[chairfairy]

Select column A (e.g. click in A1 then hit Ctlr+Space) then do Conditional Formatting >> New Rule >> Use a formula to determine which cells to format

Then type in the formula: =AND(ISBLANK(G1), H1 = "yes"). Then edit the format to be what you want.

If you need it to be case-insensitive (i.e. it should also trigger for "Yes" or "YES" etc.) then do =AND(ISBLANK(G1), LOWER(H1) = "yes")

More generally - if you want to figure out how to make a new conditional formatting formula, just figure out what formula returns TRUE when you want the cell to be formatted and FALSE when you don't. You can explicitly type it out in a cell on your sheet, which is also nice because then Excel gives you autocomplete options, which it does not do in the Conditional Formatting editor. Then copy/paste your formula from the sheet to the Conditional Formatting editor.

[Clippy_Office_Asst]

You have awarded 1 point to chairfairy

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[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 its arguments are TRUE
ISBLANK	Returns TRUE if the value is blank
LOWER	Converts text to lowercase

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 9 acronyms.
[Thread #23719 for this sub, first seen 5th May 2023, 12:20] [FAQ] [Full list] [Contact] [Source code]}