Forum Discussion
Solved
Conditional Formatting with 2 Variables where one is cell blank
Hi,
Currently trying (and failing) to conditionally formatting a certain cell in a spreadsheet. What I want C1098 to do is turn green IF there is any text in F1098 AND C1098 is blank. Any ideas? Below are screenshots of the formula I am currently using in conditional formatting.
TIA!
- n the formula field, enter the following formula:
=AND(ISBLANK(C1098), NOT(ISBLANK(F1098)))
Cell C1098 should turn green if there is any text in F1098 and C1098 is blank.
I hope this helps!
- n the formula field, enter the following formula:
=AND(ISBLANK(C1098), NOT(ISBLANK(F1098)))
Cell C1098 should turn green if there is any text in F1098 and C1098 is blank.
I hope this helps!- Thankyou so much! Fixed the problem immediately 🙂
- I am glad that I could help you with your project.
I wish you continued success with Excel!
