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...
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
- 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