More than 3 conditional formats for text color fill in excel 2003

[Wango12345]

I am working on an sheet that needs 9 conditions for text to color fill cells. I have tried a bunch of the examples and still getting errors. I need this to work on xl2003 which I run at work but am working in xl2010 at home. don't know if thats the issue. I have uploaded the sheet would appreciate any help.

[pike]

hi Wango12345
Welcome to the forum

something like

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Please Login or Register  to view this content.

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

[Wango12345]

Thanks Pike for all your help mate.......works wonderful even back filling from 2010 2003 Thx again

[pike]

Yourwelcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save