I have a question concerning conditional formatting in excel: I want to highlight one cell (lets say F1) in red but only if F6 it self is empty/blank and B1 is filled (it doesn't matter with what): How do I do it?

CodePudding user response：

Use

=AND(ISBLANK(F6),NOT(ISBLANK(B1)))

or

=AND(F6="",B1<>"")

in conditional formatting.

Result:

CodePudding user response：

1. Select cell F1
2. Open Conditional Formatting
3. Select "New rule" then "Use a formula"
4. Use a formula that results in TRUE or FALSE
5. In your case use =AND(ISBLANK(F6);NOT(ISBLANK(B1)))