Nel post news:luposlipophobia.29ur7e_1151061614.3048@excelf orum-nospam.com
*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