How to find cells with non-conditional formatting?

[Epinn]

Hi,

I know how to find cells with **conditional** formatting. Is there a way to
find cells that have non-conditional formats? Let me try to be a bit
specific. How can I find cells that I have applied custom formats
(format>cells>number>custom)?

Appreciate feedback.

Epinn

 

[Dave Peterson]

For any particular custom format...

If you're using xl2002+, you can use the Options button on the Edit|Find dialog
to specify the number format to search for.

Before xl2002, you'll have to loop through all the cells and look at each cell's
number format.

Maybe you can use some of the code here:
http://j-walk.com/ss/excel/eee/eee015.txt

Look for "SPECIAL VBA PROJECT: Custom Number Formats"

 

[Epinn]

Thank you Dave. I should specify that I use Excel 2003.

Edit>Find>Options ..... is neat. I think CELL() is useful as well.

Thank you for the link. I found an interesting tip via Google and then I
realized that it was also from the same site.
http://j-walk.com/ss/excel/usertips/tip045.htm The tip mentioned using
Get.Cell. I understand that I can't use it in a worksheet directly. But is
it still available for 2003 version? "48" is for formula (see below); what
is the number for format please? I am hoping that I can use a similar
formula to search for all cells that have formatting. Please advise.

*****************
=GET.CELL(48,INDIRECT("rc",FALSE))

Using a value of 48 as the first argument for GET.CELL causes the function
to return 'True' if the cell contains a formula.
*********************

By the way, I can't decide whether it should be "non-conditional" or
"unconditional."

Thanks!

Epinn

 

[Dave Peterson]

The number is 7 to return the format of the cell.

But I'm not sure how this will help.