In Excel 2003 I want to apply conditional formats to entire worksheets to highlight with colour a) cells with constant numerical values, including formulae with no external references (e.g. a volume entered as a product of 3 numbers); b) cells containing formulae that don't reduce to constant value (i.e. with references to other cells).
I'm 90% there using the function IsNumber and a function created in Virtual Basic:
My problem is how do I identify cells with constant value formulae to colour them as a) rather than b)?
Bookmarks