Conditional format based on VBA

[Sharp]

Hi,

I’m using the following code to add formulas based on data entered into other cells.

Please Login or Register  to view this content.

I have managed to add data validation to cells as below…

Please Login or Register  to view this content.

But I want to add conditional formatting. I rescored the macro below but can’t seem to adapt it.

Please Login or Register  to view this content.

I will also need the formula below

Please Login or Register  to view this content.

to be range row based as the other code is….any ideas on how to get round this

thanks

[StephenR]

I'm a bit lost. Could you explain in plain English what you're trying to do? Do you want CF with two conditions?

[Sharp]

Hi,

i'm basically trying to say that if column 'B' has 'Total' written in it then apply conditionig formatting to this cell.

The conditional formatting should say that if 'B' = 'Total' than check the same row in column 'Z', if column 'Z' value is empty then turn 'B' red.

thanks