highlighting cells that have desired results

[luposlipophobia]

I am using the countif function to analyis the number of times certai
numbers occur. Is there a way to have Excel highlight the cell usin
the countif function when the result is "0" for example.

That is, say the data A1:E2 being analyzed is as follows:
1 3 9 5 20
5 4 2 5 5

A4 uses the countif command to check for 7s. So, in addition to a "0
being displayed in A4, I want A4 to be highlighted so I can notice i
immediately. That is, in actuality, I am viewing a much larger set o
data and wish to notice the numbers with "0" hits right away.

Any ideas?

Thanks in advance

 

[Franz Verga]

Nel post *luposlipophobia* ha scritto:

I am using the countif function to analyis the number of times certain
numbers occur. Is there a way to have Excel highlight the cell using
the countif function when the result is "0" for example.

That is, say the data A1:E2 being analyzed is as follows:
1 3 9 5 20
5 4 2 5 5

A4 uses the countif command to check for 7s. So, in addition to a "0"
being displayed in A4, I want A4 to be highlighted so I can notice it
immediately. That is, in actuality, I am viewing a much larger set of
data and wish to notice the numbers with "0" hits right away.

Hi,

You can use Conditional Formatting.
First select your range then menu Format, Conditional Formatting, under
Condition 1 select CellValueIs then select equals to and then type 0. Click
on Format, choose your format, then click Ok twice.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Guest]

Try conditional format* on A4 with the formula:
=AND(A4=0,A4<>"")

*Click Format > Cond Format

 

[luposlipophobia]

Thanks! Conditional formatting was the trick!

 

[Guest]

Thanks! Conditional formatting was the trick!

You're welcome (from us) !
Appreciate your feedback ..

---