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

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

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

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