Ok here take a look at this. i've made a place for you to paste the data you have...up to 1000 rows. The other sheets read off of that. Take a look at the formula's in the conditional formating>manage rules... choose this worksheet, and you'll see how the formulas in here are basically like an if statement that control the formatting. Pay close attention to the hierarchy of the 3 conditional formatting formulas.
Play around with it and let me know if you have any questions.
br,
Mike
Bookmarks