Using cell color as criteria

[Guest]

Hi, I'd like to write a formula with IF function, using a cell color as a
criteria. Is this possible?

Like,
=IF([cell.fill.color]=red,[dothis],[dothat])

Thanks.

 

[Don Guillett]

if range("a1").interior.ColorIndex=3 then msgbox "hi"

 

[Earl Kiosterud]

Susan,

Before you pursue this, check out Formatting as data (sorting on color, etc.) at
http://www.smokeylake.com/excel/excel_truths.htm.
--
Earl Kiosterud
www.smokeylake.com

Note: The norm in these groups is to top-post.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Guest]

Hi Susan,

It looks like you are trying to do this with a spreadsheet function - you
can't, you need to use VBA.

You can either create a custom VBA FUNCTION depending on what you mean by
"do this" or a VBA subroutine, which is what Don is alluding to .

 

[Guest]

Yeah, I didn't think I could do it with a simple spreadsheet function.

Thanks all for responses! I will look into the VBA solution.

Hi Susan,

It looks like you are trying to do this with a spreadsheet function - you
can't, you need to use VBA.

You can either create a custom VBA FUNCTION depending on what you mean by
"do this" or a VBA subroutine, which is what Don is alluding to .
--
Thanks,
Shane Devenshire

Hi, I'd like to write a formula with IF function, using a cell color as a
criteria. Is this possible?

Like,
=IF([cell.fill.color]=red,[dothis],[dothat])

Thanks.

 

[Bob Phillips]

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Don Guillett]

See my post

--
Don Guillett
SalesAid Software
(e-mail address removed)

Yeah, I didn't think I could do it with a simple spreadsheet function.

Thanks all for responses! I will look into the VBA solution.

Hi Susan,

It looks like you are trying to do this with a spreadsheet function - you
can't, you need to use VBA.

You can either create a custom VBA FUNCTION depending on what you mean by
"do this" or a VBA subroutine, which is what Don is alluding to .
--
Thanks,
Shane Devenshire

Hi, I'd like to write a formula with IF function, using a cell color as
a
criteria. Is this possible?

Like,
=IF([cell.fill.color]=red,[dothis],[dothat])

Thanks.