LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Working with worksheets

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working across multiple worksheets Imrac Excel Discussion (Misc queries) 1 April 23rd 06 06:26 AM
Working with worksheets in excel Nancy Excel Discussion (Misc queries) 2 April 19th 06 11:46 PM
Working with several worksheets Alexandre Duarte Excel Discussion (Misc queries) 9 December 7th 05 02:59 PM
Working with multiple worksheets Paul Excel Discussion (Misc queries) 1 November 3rd 05 03:03 AM
working with data between worksheets steve Excel Discussion (Misc queries) 1 August 10th 05 01:16 PM


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"