highlighting cells that have desired results
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 |
highlighting cells that have desired results
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 |
highlighting cells that have desired results
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 |
highlighting cells that have desired results
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 |
highlighting cells that have desired results
"luposlipophobia" wrote:
Thanks! Conditional formatting was the trick! You're welcome (from us) ! Appreciate your feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com