Conditional Formatting - Excel

Question

Community, I have a pretty simple problem today. I'm pretty new at Excel formatting. Anyways, I have a box that is going to change the font color of a box from white to black if a condition is true. There are technically two conditions and I think the way I set one of the conditions is wrong anyways.

=NOT($K$4="") //first condition, if box K4 != blank (works)
=NOT($K$4="No") //second condition, if box K4 != No (does not work)

Is there a way to combine those two and if so how? Secondly, if not, am I writing the second condition properly?

Jerry · Accepted Answer · 2013-10-10 12:59:22Z

2

You can easily discard the NOT() and use AND() to combine two conditions:

=AND($K$4<>"", $K$4<>"No")

If K4 is neither blank nor contains No, then format (in other words, don't format if K4 is blank or contains 'No').

<> means 'not equal to' in excel formulae.

answered Oct 10, 2013 at 12:59

Jerry

71.8k14 gold badges106 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional Formatting - Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related