Conditional Formatting

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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....

 

[Guest]

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))

 

[Guest]

Perfect! Thank you! I knew it had to be me

 

[Guest]

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))"

 

[Guest]

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
=).

 

[Guest]

Glad to help, Thanks for the feedback.

Perfect! Thank you! I knew it had to be me