Hi,

I was wondering if anyone might be able to help me here.

for example
in worksheet "sheet1",
A B C
1 server1 200 200
2 server2 300 300
3 PC1 200 150
4 ...

what i would like to do is, imagine, we have yellow color all over row
1, 2, 3, etc. If someone comes in and change the value at cell, B2,
from 300 to 200, i like the color changed to, for example red. But if
another person comes in and changes it back to 300, the color changes
back to yellow from red. So, i thought i may use worksheet "sheet2",
and make it exactly the same as sheet1. Everything is the same, just a
replica of sheet1. But then, i discovered that excel doesn't allow to
work between worksheets in terms of conditional formatting. The message
that i got read as follows

"You may not use references to other worksheets or ... for conditional
formatting criteria."

So, what should i do in order to be able to do the things i want it
to?

Thank you in advance.


--
associates
------------------------------------------------------------------------
associates's Profile: http://www.excelforum.com/member.php...o&userid=35073
View this thread: http://www.excelforum.com/showthread...hreadid=548499