Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find cells with non-conditional formatting?
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 (formatcellsnumbercustom)? Appreciate feedback. Epinn |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find cells with non-conditional formatting?
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 he http://j-walk.com/ss/excel/eee/eee015.txt Look for "SPECIAL VBA PROJECT: Custom Number Formats" Epinn wrote: 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 (formatcellsnumbercustom)? Appreciate feedback. Epinn -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find cells with non-conditional formatting?
Thank you Dave. I should specify that I use Excel 2003.
EditFindOptions ..... 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" wrote in message ... 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 he http://j-walk.com/ss/excel/eee/eee015.txt Look for "SPECIAL VBA PROJECT: Custom Number Formats" Epinn wrote: 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 (formatcellsnumbercustom)? Appreciate feedback. Epinn -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find cells with non-conditional formatting?
The number is 7 to return the format of the cell.
But I'm not sure how this will help. Epinn wrote: Thank you Dave. I should specify that I use Excel 2003. EditFindOptions ..... 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" wrote in message ... 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 he http://j-walk.com/ss/excel/eee/eee015.txt Look for "SPECIAL VBA PROJECT: Custom Number Formats" Epinn wrote: 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 (formatcellsnumbercustom)? Appreciate feedback. Epinn -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Frame cells with Outline Border | Excel Discussion (Misc queries) | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
Conditional Formatting based on other cells | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
how do I maintain my conditional formatting when filtering cells? | Excel Worksheet Functions |