IF statement using formatting criteria (NOT conditional formatting)

**chelseasikoebs** · 05-05-2009, 10:51 PM

Is there "code" for different formatting in a spreadsheet so you can use an IF statement to do something like:

if(A1=blue background,"Yes","No")

or

if(A1=red text,"Yes","No")

etc.?? But replace "blue background" and "red text" with some sort of number code? I want to compile a list of the items that are formatted with certain background colors and/or text colors and then organize only those items into a chart.

**sweep** · 05-06-2009, 12:06 PM

Hi,

You'll need a user defined function to do this.

Foe example,

Please Login or Register  to view this content.

This will return the value of the fill colour of A1.

=FILLCOLOUR(A1)

**chelseasikoebs** · 05-06-2009, 09:25 PM

then would I put in a formula like this to get it to work?:

=IF(K1=fillcolour(A1),"yes it's the same color","no it's not the same color")

**chelseasikoebs** · 05-06-2009, 09:26 PM

oh, wait. once I have the value of the fill color, then I can use THAT in a function? Such as:

=if(k1=-4701,"yes it's the same color","no it's not the same color")

**chelseasikoebs** · 05-06-2009, 09:28 PM

oh my gosh, I'm sorry. I'm playing with it more now and I see how to use it! THANKS SOOOO MUCH!!!

**JBeaucaire** · 05-07-2009, 01:57 AM

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].

(Also, use the "scales" icon across from the post dates to leave Feedback, it is appreciated)