I want to use an IF Statement in excel to check cell pattern-how?

[Guest]

I am using nested IF staements to check value conditions of cells. As wel as
checking for blanks and acceptable values I want to check if the Cell Pattern
<> Red. Can this final check be done in the IF statement.

Appreciate any help ?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Pete_UK]

Try this link to Chip Pearson's site:

http://www.cpearson.com/excel/colors.htm

A user-defined function can return the background colour of a cell, so
you could use this in your formula.

Hope this helps.

Pete

 

[Guest]

Hi Bob,

Thanks for the reply. The colorindex reference is useful but is it true that
I can not use it directly in an IF statement, do I have to use it in VBA
coding ?

 

[Guest]

Thanks Pete,

Good link but unfortunately I do not want to have to use VBA

Regards
Aidan

 

[Pete_UK]

There is no standard function in Excel to return the background colour
of a cell - you have to make your own, and that means a bit of VBA.

Pete

 

[Bob Phillips]

It's VBA or nothing, and even the VBA has constraints.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

What's a guy in the UK doing posting at 2:05 am?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Pete_UK]

I've told you before that I fly with the owls !! <bg>

Pete

 

[Bob Phillips]

That's close to the dawn chorus!

Bob

I've told you before that I fly with the owls !! <bg>

Pete

 

[Pete_UK]

And I was back in action for 8:30am !! All you sleepy-heads who need 8
hours sleep - you waste so much of your life <vbg>

Pete

 

[Bob Phillips]

Mate, as I get older, I need more.

Bob

And I was back in action for 8:30am !! All you sleepy-heads who need 8
hours sleep - you waste so much of your life <vbg>

Pete