multiple conditional format conditions changed based on another cells value?

A1:A6 have numeric values 1 to 6.

I want the conditional format values to change Based on the value in Cell B2.

If the value in B2 is "old", then I want these conditional format conditions for A1:A6. Numbers between 1-2=green text, 3-4=orange text and 5-6=red text.

IF the value in B2 is "new" then I want the conditional format conditions in A1:A6 to change so 1=black text, 2-3=green text, 4-5=orange text and 6=red text.

I know how to do multiple conditional formats but i have no clue how to change multiple conditions based on another cells value.

I hope this is simple and easy to understand. Thanks in advance.

You will need 7 rules if you do via Conditional Formatting as the colour can't be varied on one rule based on a variable... given you're running XL2007 this isn't a problem but note on earlier versions a max of 3 conditional formats can be applied (in addition to default) so this would not be backwards compatible.

ie

Higlight A1:A6

To implement choose "Use a Formula" in the Conditional Formatting dialog:

=AND($B$2="old",OR($A1=1,$A1=2))
format Green text

=AND($B$2="new",A1=1)
format black text

etc...

I'm glad it worked though no need to quote my reply in your post - I've taken the liberty of removing it.

Do post back if you have any further problems.

It would depend on what significance they have... if you want to apply a rule for all values between 1 and 2 then

=AND($B$2="old",$A1>=1,$A1<=2)

it will all depend on what the rules are - not clear I'm afraid.