Conditional Formatting
 

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?
--
Thanks for your help!

Conditional Formatting
 

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.

Conditional Formatting
 

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....
--
Thanks for your help!


"Sloth" wrote:

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.

Conditional Formatting
 

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)),"",vlo okup(a2,input1,2,false))

"TamIam" wrote:

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....
--
Thanks for your help!


"Sloth" wrote:

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.

Conditional Formatting
 

Perfect! Thank you! I knew it had to be me :)
--
Thanks for your help!


"Gav123" wrote:

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)),"",vlo okup(a2,input1,2,false))

"TamIam" wrote:

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....
--
Thanks for your help!


"Sloth" wrote:

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.

Conditional Formatting
 

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

"Gav123" wrote:

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)),"",vlo okup(a2,input1,2,false))

"TamIam" wrote:

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....
--
Thanks for your help!


"Sloth" wrote:

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.

Conditional Formatting
 

Glad to help, Thanks for the feedback.

"TamIam" wrote:

Perfect! Thank you! I knew it had to be me :)
--
Thanks for your help!


"Gav123" wrote:

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)),"",vlo okup(a2,input1,2,false))

"TamIam" wrote:

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....
--
Thanks for your help!


"Sloth" wrote:

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.

Conditional Formatting
 

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

"Sloth" wrote:

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

"Gav123" wrote:

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)),"",vlo okup(a2,input1,2,false))

"TamIam" wrote:

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....
--
Thanks for your help!


"Sloth" wrote:

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.