Prev: Zero's plotted in charts?
Next: Missing fill handle
From: KHW on 27 May 2010 16:53
HI Bob,

but then once a name range is defined, how can we apply the conditional
format to go down an entire column for example?

if:
namerange1( ) = namerange2 ( )
then make namerange1 ( ) call yellow background.

namerange1 and namerange2 are on two different worksheets.

thank you.

"Bob Phillips" wrote:

> It is allowed, but any range that you refer to on another sheet must be
> referenced by way of a named range (Insert>Name>Define...).
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "jkl" <jkl(a)discussions.microsoft.com> wrote in message
> news:FFC8139F-7449-49BC-B4D8-0A5DEE513F98(a)microsoft.com...
> > My version of Excel informs me that condtional formatting across
> > worksheets
> > is not allowed. Is that the case for the latest versions of Excel as
> > well?
> > If so, does anyone have a handy way of getting around this limitation? I
> > am
> > trying to use dates in one worksheet to allow me to generate a gantt chart
> > in
> > another worksheet. The best I can do at this point is copy the date info
> > from the first sheet into the second sheet and then do conditional
> > formatting
> > within the second sheet. I'd just as soon avoid having the date columns
> > in
> > the second sheet since the gantt charts will display the dates. In
> > addition, when doing the conditional formatting, the cells keep displaying
> > the result (TRUE or FALSE). This makes the gantt chart look pretty silly.
> > Any way I can tell Excel not to make the result visible but still provide
> > the
> > format requested (in this case, color shading). THANKS!
>
>
>
 | 
Pages: 1
Prev: Zero's plotted in charts?
Next: Missing fill handle