iscolor function

[mr_hiboy]

Hi all,


I am using the follwoing formula to indicate wether cell A1 is shaded or not.


=IF(iscolor(A1)=TRUE,0,1) - althoguh it seems tad backward this formula it does work.


It works fine if the cell is shaded when you type the forula, but if you remove the shading, the result does not change? Any ideas.


I'd be happy enough having to press a button to update.


Thanks

Paul

 

[Luke M]

What is the IsColor function? I'm assuming that's a UDF you are using, as it's not native to XL.


Perhaps you could have the buttom/command button run a macro to recalculate those cells? Something like:


Sub RefreshCells()

Range("A:B").Calculate

End Sub

 

[mr_hiboy]

Thanks Luke, works a treat.


I used isColor in a few year back, not sure where I dug it out from, but it has just saved 4 hours a week for a member of my team!