Vba code conditional format

[RJ1969]

Hello,

What is the vba code for conditional formatting to set a red text for the specific text ?denied? and ?granted? blue? I tried to set the conditional formatting that contain the specific text but for some reason it is not working due to the vba code that I already have in the ?thisworkbook?.

I do really need to keep the codes that I already have.

Is it possible to try to set it in the vba code?

Thanks.

[thomglea]

Maybe something along the lines of this?

Please Login or Register  to view this content.

[RJ1969]

Hi

It did not work.