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.

"ShaneDevenshire" wrote:

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


"Susan" wrote:

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.