View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
veggies27 veggies27 is offline
external usenet poster
 
Posts: 28
Default 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!