Conditional Formating Help

[johnph]

Hello,

I am in need of help. I want to apply a conditonal formating to a range of cells when a person opens up a marcro-enabled (private sub, I think) workbook. I tried to record the macro, but that does not work .

For columns N, P, R, T, V
I need the conditional formatting to fill the cell red if it IS NOT blank (No Blank)

For columns M, O, Q, S, U
I need the conditonal formatting to fill the cell red if it IS blank (Blank)

There is a way to format this when the worksheet is open correct? Any help on this would be amazing,

Thank you.

[Winon]

Hello johnph,

Do you want it like this?

Also see the "Please consider" note at the bottom of this post.

[johnph]

Correct this is exactly how I want it, however I want it to apply as soon as the document opens via VBA. Is this possible?

[Winon]

Hi johnph,

It does not really matter how the sheet is opened or activated, via vba or not, it will do its thing.

[johnph]

Hmm ok. Let me see.. one second

[johnph]

Ok you're right there is no reason to... Ok new question Winon (if you dont mind answering)

How to I format in conditonal format: if "B1" is filled then HIGHLIGHT "A1", if "B2" is filled then HIGHLIGHT "A2", etc

[Winon]

Hi johnph,

Easy, see attached revised WorkBook.

[johnph]

Thank you so much winon. Sorry for the late reply.

[Winon]

Hi johnph,

You are welcome.