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

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 ?

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

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)

"Aidan" wrote in message
...
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 ?

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

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

Aidan wrote:
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 ?

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

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 ?

"Bob Phillips" wrote:

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)

"Aidan" wrote in message
...
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 ?

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

Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

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

Aidan wrote:
Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

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

--
HTH

Bob Phillips

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

"Aidan" wrote in message
...
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 ?

"Bob Phillips" wrote:

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)

"Aidan" wrote in message
...
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 ?

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

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" wrote in message
oups.com...
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

Aidan wrote:
Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

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

Pete

Bob Phillips wrote:
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" wrote in message
oups.com...
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

Aidan wrote:
Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

That's close to the dawn chorus!

Bob

"Pete_UK" wrote in message
ups.com...
I've told you before that I fly with the owls !! <bg

Pete

Bob Phillips wrote:
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" wrote in message
oups.com...
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

Aidan wrote:
Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

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 wrote:
That's close to the dawn chorus!

Bob

"Pete_UK" wrote in message
ups.com...
I've told you before that I fly with the owls !! <bg

Pete

Bob Phillips wrote:
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" wrote in message
oups.com...
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

Aidan wrote:
Thanks Pete,

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

Regards
Aidan

"Pete_UK" wrote:

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

Aidan wrote:
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 ?

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

Mate, as I get older, I need more.

Bob

"Pete_UK" wrote in message
ups.com...
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 wrote:
That's close to the dawn chorus!

Bob