Forum Discussion
Help with Conditional Formatting
Hi!
I can't find a way to make this conditional formatting work how I need. The columns that I am working with are A, E and F. I need to set up conditional formatting for column A.
| ID (A) | Prefix (B) | FirstName (C) | LastName (D) | Phone (E) | Complete (F) |
| 63077 | Mrs. | First | Last | Phone | x |
| 171015 | Mrs. | First | Last | ||
| 26473 | Mrs. | First | Last | x | |
| 6685 | Mr & Mrs | First | Last | Phone | x |
| 127225 | First | Last | Phone | x |
The formatting should be as follows:
If E is blank/empty and F is blank/empty, A is filled Yellow.
If E is blank/empty and F has "x" value, Stop Rule.
Can someone help me figure out how to do this?
Thanks!
10 Replies
Hi Carly,
On you sample, if first column is A, you have columns from A to F. What is G?
- Oh, that was a typo! It should read Columns A, E, and F.
Okay, thank you.
You may apply the rule
=ISBLANK($E2)*ISBLANK($F2)*NOT(ISBLANK($A2))
to your column A to fill it yellow if both E and F are blank, no need in Stop rules. As attached
