See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"james" wrote in message
...
Thanks Mike. My problem got solved. I have another question. Can I use the
"the formula is" under conditional formating to get a cell to indicate a
colour. And if yes how. I know that with a "value is" and formating one
can
do that.

Thanks in advance

"Mike H" skrev:

James,

A bit short on detail but at its simplest this

=Sheet2!A1

in a cell on sheet 1 (or in fact any sheet) would return the value in
sheet
2 cell A1

Mike

"james" wrote:

Hi out there

Please I need help with working between worksheets. I have some values
in
work sheet 2 which I need to correspond with results in worksheet 1.
How do I
go about it