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.

Any ideas?

Thanks in advance.


--
luposlipophobia
------------------------------------------------------------------------
luposlipophobia's Profile: http://www.excelforum.com/member.php...o&userid=35655
View this thread: http://www.excelforum.com/showthread...hreadid=554929

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

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

*Click Format Cond Format
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"luposlipophobia" wrote:

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.

Any ideas?

Thanks in advance.


--
luposlipophobia
------------------------------------------------------------------------
luposlipophobia's Profile: http://www.excelforum.com/member.php...o&userid=35655
View this thread: http://www.excelforum.com/showthread...hreadid=554929

Thanks! Conditional formatting was the trick!


--
luposlipophobia
------------------------------------------------------------------------
luposlipophobia's Profile: http://www.excelforum.com/member.php...o&userid=35655
View this thread: http://www.excelforum.com/showthread...hreadid=554929

"luposlipophobia" wrote:
Thanks! Conditional formatting was the trick!

You're welcome (from us) !
Appreciate your feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---