ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   COUNTIF Function (https://www.excelbanter.com/excel-worksheet-functions/65080-countif-function.html)

nyys

COUNTIF Function
 
Is there a was to use the COUNTIF function if a cell has been formated in a
certain way?

I'm trying to count the cells that have been BOLDED.

thanks,
-paul

wjohnson

COUNTIF Function
 

If your "BOLD" is formatted using "CONDITIONAL" format then you should
be able to do a count against "whatever" causes the cell to format to
BOLD.
If you "manually" BOLD the cell - probably not.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=501137


JE McGimpsey

COUNTIF Function
 
See

http://www.mcgimpsey.com/excel/udfs/sumbold.html


In article ,
"nyys" wrote:

Is there a was to use the COUNTIF function if a cell has been formated in a
certain way?

I'm trying to count the cells that have been BOLDED.

thanks,
-paul



All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com