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

excel

NikolinoDE
Apr 25, 2023
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!

NikolinoDE

Gold Contributor

Apr 25, 2023

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!

littlebethan
Copper Contributor
Apr 25, 2023
Thankyou so much! Fixed the problem immediately 🙂
- NikolinoDE
  Gold Contributor
  Apr 25, 2023
  I am glad that I could help you with your project.
  
  I wish you continued success with Excel!

Forum Discussion

Conditional Formatting with 2 Variables where one is cell blank

Resources