One detail would be.............how are the values on sheet2 input?

Calculated or manually?


Gord

On Wed, 13 Jan 2010 16:47:13 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

More details please.

Use sheet names and cell references rather than generic terms like "cell".

Yes, you can CF a cell on sheet1 based upon a value in a cell on sheet2.

You just have to give the value cell a defined name.

But with 6 formats you will need VBA or if the values are numeric you can
get up to 6 without VBA

See John McGimpsey's site for details of that.

http://www.mcgimpsey.com/excel/conditional6.html


Gord

On Wed, 13 Jan 2010 16:15:01 -0800, Tracey
wrote:

Thanks for the reply Gord - my real question is a bit more complex...

I really need to know if it's possible to CF a cell on one worksheet based
on a value on a 2nd worksheet. To complicate it further, I have a total of 6
formats that I would like to apply.