Conditional Formatting

T

TamIam

Good day!

I have created a spreadsheet that is mostly comprised of vlookup statements,
and what I would like to know is if there is a way to conditionally format
the cell the change colour when I have manually typed over the formula? Does
that make any sense?
 
S

Sloth

Click Format->Conditional Formatting
Select "Cell Value is"
and "not equal to"
enter the formula as the condition.
click Format and select the properties you want.

Not exactly what you wanted, but I think it should work until someone
provides you with a better solution.
 
T

TamIam

Thanks for the help, but it doesn't seem to be working, perhaps I'm doing it
wrong, but when I have my formula reading
=if(isna(vlookup(a2,input1,2,false)),"",vlookup(a2,input1,2,false)) in the
'not equal to' section, it still coloured the cell....
 
G

Gav123

Remove the = in the 'not equal to' section of your conditional format and it
should work..
It should
read....if(isna(vlookup(a2,input1,2,false)),"",vlookup(a2,input1,2,false))
 
S

Sloth

what version of Excel are you running?

Excel 2000 requires the = at the beginning. If I enter the formula without
it, then the formula changes to something like this...
="if(isna(vlookup(a2,input1,2,false)),"""",vlookup(a2,input1,2,false))"
 
G

Gav123

It's the same with Excel 2003.. I think the conditional format recognises
that it is a formula and it only looks for the condition (the part after the
=).
 
Top