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.