Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula based on cell formats
Is there a way to use an IF formula to pull information from cells based on
whether the formatting of the cell matches the criteria formatting. ie...in words, I'd like to do this. If F1 is shaded with the dot pattern, pull A1:E1 to a summary sheet. I already have an array-entered IF formula that currently says: If F1 = "a", pull A1:E1 to the summary sheet...I just want to see if formattign can be recognized with normal formulas. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula based on cell formats
A standard function can not be used to determine formats - you would need to
have a user-defined function to do that. Chip Pearson has some notes on reading colours he http://www.cpearson.com/excel/colors.aspx Perhaps you can get some ideas from his site. Hope this helps. Pete "veggies27" wrote in message ... Is there a way to use an IF formula to pull information from cells based on whether the formatting of the cell matches the criteria formatting. ie...in words, I'd like to do this. If F1 is shaded with the dot pattern, pull A1:E1 to a summary sheet. I already have an array-entered IF formula that currently says: If F1 = "a", pull A1:E1 to the summary sheet...I just want to see if formattign can be recognized with normal formulas. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a macro that Formats a textbox based on value in a cell | Excel Worksheet Functions | |||
conditional formats based on If | Excel Worksheet Functions | |||
Copy Color Formats Based On Column Date Values | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |