Myrna Larson

Posts: n/a

I haven't explored this, but you have have to put a cell on Sheet2 with the
formula =Sheet1!A1 and refer to that cell in your CF formula.

On Sun, 13 Feb 2005 19:56:56 -0800, "Patrick Simonds"
wrote:

Is there any way to do conditional formatting across two worksheets? So for
example if cell A1 on sheet 1 = 10 then cell A1 on sheet 2 is red.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
more than 3 conditional formating in excel	Manan	Excel Discussion (Misc queries)	2	February 7th 05 09:12 PM
Conditional Formating	csfrolich	Excel Discussion (Misc queries)	2	January 17th 05 02:07 PM
Conditional Formating when result is text	Lary	Excel Worksheet Functions	1	December 16th 04 02:13 AM
Conditional hiding of worksheets	KG	Excel Discussion (Misc queries)	0	December 2nd 04 05:29 PM
30 Day Aging Report Using Conditional Formating	Tiegris	Excel Worksheet Functions	0	November 4th 04 10:07 PM

All times are GMT +1. The time now is 11:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us