Conditional formatting - cannot reference another worksheet?

nancyo · May 14th, 2002, 10:58 AM

I am setting up a workbook with several worksheets. The first worksheet will have a list of "specifications", which will be referenced in multiple formulas on multiple worksheets. This is so that IF and WHEN the specs change, I only have to change the actual specs and not hundreds of formulas.

I am setting up conditional formatting to also refer to these "specs". When I tried to reference the first worksheet in the conditional formatting on the other worksheets, it does not work.

I have figured out a round-about-way to get around this, but was wondering if anyone knew of a direct way? I don't really want to use name-define, as there are many specs. But, if this is the only way, I am willing to do so.

Von Pookie · May 14th, 2002, 12:40 PM

Unfortunately, I think you will have to use the long way you found to do this.

Data validation doesn't let you use a source from another sheet, either. When I was setting that up, I had to name the range and use that.

_________________
~*Kristy*~

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

[ This Message was edited by: Von Pookie on 2002-05-14 11:42 ]

nancyo · May 14th, 2002, 12:43 PM

OK - thanks! Thought so...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 10:58 AM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I am setting up a workbook with several worksheets. The first worksheet will have a list of "specifications", which will be referenced in multiple formulas on multiple worksheets. This is so that IF and WHEN the specs change, I only have to change the actual specs and not hundreds of formulas. I am setting up conditional formatting to also refer to these "specs". When I tried to reference the first worksheet in the conditional formatting on the other worksheets, it does not work. I have figured out a round-about-way to get around this, but was wondering if anyone knew of a direct way? I don't really want to use name-define, as there are many specs. But, if this is the only way, I am willing to do so.

May 14th, 2002, 12:40 PM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Unfortunately, I think you will have to use the long way you found to do this. Data validation doesn't let you use a source from another sheet, either. When I was setting that up, I had to name the range and use that. _________________ ~Kristy~ "Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam." [ This Message was edited by: Von Pookie on 2002-05-14 11:42 ]

May 14th, 2002, 12:43 PM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	OK - thanks! Thought so...