Conditional Formatting more than 3

[ujpest]

I have using the following code for conditional formatting

Please Login or Register  to view this content.

This works fine in itself however it only works if I put the code in a worksheet but I need it to apply to multiple worksheets (some are yet to be created). So when I put the code into "ThisWorkbook" the conditional formatting does not work.

Thank you

[arlu1201]

You can do this -

Put the code in a standard module and have a code like this

Please Login or Register  to view this content.

[ujpest]

Hi Arlette,

Like this, if so it is not working

Please Login or Register  to view this content.

Also did you happen to have chance to look at my other post regarding auto allocation?

thank you

Ian

[arlu1201]

You need to put the code in a standard module -

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button.

Also change this line from

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[ujpest]

Thank you. Your support is very welcome. The issue is now solved
Thank you