Using cell color as criteria
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.
|