Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |