Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to include conditional formats
When using vlookups, is it possible for the function to transfer conditional
formating as well from the source worksheet, in addition to content? -- thank you, Trish |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to include conditional formats
Hi,
Formulas don't do that. You could conditionally format the formula or use VBA. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Trish" wrote: When using vlookups, is it possible for the function to transfer conditional formating as well from the source worksheet, in addition to content? -- thank you, Trish |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to include conditional formats
How do you conditional format a vlookup formula? What is VBA?
-- thank you, Trish "Shane Devenshire" wrote: Hi, Formulas don't do that. You could conditionally format the formula or use VBA. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Trish" wrote: When using vlookups, is it possible for the function to transfer conditional formating as well from the source worksheet, in addition to content? -- thank you, Trish |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup to include conditional formats
Hi,
You apply condtional formatting to the cell where the VLOOKUP is. VBA is Excel's programming language. Of course to help more we would need to know more, like what is the condtion that formats the original cells. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Trish" wrote: How do you conditional format a vlookup formula? What is VBA? -- thank you, Trish "Shane Devenshire" wrote: Hi, Formulas don't do that. You could conditionally format the formula or use VBA. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Trish" wrote: When using vlookups, is it possible for the function to transfer conditional formating as well from the source worksheet, in addition to content? -- thank you, Trish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
vlookup to include text | Excel Worksheet Functions | |||
vlookup formats | Excel Worksheet Functions | |||
change ten digits in a cell to include phone # formats | Excel Discussion (Misc queries) |