conditional formatting with more than 3 conditions excel 2003

You can try this out.
Right click the sheet tab, choose view code, then paste the code into the window that comes up. Make sure you enable macros.

Please Login or Register  to view this content.

Good Luck!!!


If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.

It works on the worksheet change event. It's like regular conditional formatting, you don't push a button it works when the numbers change.

Originally Posted by samktlim

you see i am a novice at visual basics, i did you you advised like right clicking on the sheet tab and pasting the code onto it,,,but nothing happens when the target cell value is changed,, it remains white...can you be so kind as to put the code into the sample sheet and reverting it to me...

It's already there. Post #2.

Look at my instructions for installing the code. Right click the sheet tab and choose the menu option view code. Another alternative is Alt + F11, on the left side of the window you should see the project explorer with the name of the spreadsheet and the sheet names. If not hit Control + R. If the sheet names don't show up click the + next to the workbook name to expand the sheet names. Right click on the sheet name in question and choose view code, or you should be able to double click on the sheet name in the project explorer and the code will show up. I'm not making the code invisible you have to make the effort to look at it.

One.png

Two.png

oh..i did not notice that..got it and tried it out...it did work but the last colour of blue does not work...
also

My fault I was tired and I was copying and pasting and forgot to fix the code, but you're changing the condition from what is on your spreadsheet anyway.

condition 4 should be e10 is equal to or bigger than d10 and

That's nowhere to be found in your post and your spreadsheet says this.
if e10=d10

condition 1 should be e10 equals to or smaller than c10

Same as above and this is what is in your spreadsheet.
if e10=c10

what if i want another column i10:i15 to have the same formatting conditions...

You already know the answer to that question. There would need to be more code written.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.


If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.

If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.