need a macro to convert conditionally formatted cells color to excel colors.

[efi007]

Hi,

i m trying to search a code to convert conditionally formatted colors to normal excel colors. because i have another macro which puts specific values in those colored cells so far i m failed to do so. please also let me know how to evaluate conditional formatting formula in vba.

BR.
IZ

[alansidman]

Tell us specifically what is in the cells that needs to be formatted. What type of formatting is required for those cells and in particular where are they located, ie. column B?

Specificity is important when building VBA code.

[Andy Pope]

you might find the DisplayFormat object useful

Please Login or Register  to view this content.

[efi007]

Thanks Alansidman, i have attached my sheet. in which two macro's. in which 2 macro's. 1 is putting values to conditionally formatted cells (which is not reading the conditionally formatted colors). I am trying to build second one to give excel colors to conditionally formatted colored cells but i failed to do so.

please check.

Regards,
IZ

[efi007]

Thanks Andy you have solved my problem

Thanks Everyone