Conditional Formatting

S

Shane

Is there a way of doing Conditional formatting, based on more than three
criteria? I want a cell colour to change to one of 10 colours depending on
the lookup value of another cell! (ie cell A2 will contain a name, and cells
A3 will then contain the team, which it has looked up)

Thanks
Shane
 
Top