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) P...
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
- This still isn't working. When I put in the formula it highlights column A3 that has data in column F3.
There is nothing in F3
- Sorry, on my other document where I am putting the code. To reference this example given when I put in this code is highlights A2, while leaving A3 untouched.