Another conditional formatting headache Hi So I\'m applying some conditional for

Question

Another conditional formatting headache

Hi

So I'm applying some conditional formatting to a worksheet and I have the formula working correctly. A positive result turns the column green a negative one leaves the field red.

The problem I have is that until the data is input into the column the field remains green.

As this is to track sales of a new product line, we don't currently have figures to input for some of the rows yet but the conditional formatting will show as true and thus green. This of course changes as and when we have data to input and the correct formatting applies i.e red, until the conditions are met.

Is there any way for the conditional formatting to trigger only when data is input? Or can anyone help me with a workaround for this?

Simply put the formula works as is, I just don't want it showing a sea of green for rows with zero entries.

Hope this makes sense

Explanation / Answer

$@Try it like this:"

=AND(E4<>"",E4>=C4*$N$3)

or possibly this one which ensures there must be a number in C4 and E4 to evaluate as TRUE:|"":

=AND(COUNT(E4,C4)=2,E4>=C4*$N$3)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.