Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Hey, All You MS Excel Gurus Out There...

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Hey, It Worked!!!!

Thanks!

I knew I could get a quick answer. That took about two hours, tops (during
which time I was getting other important things done, like whipping the ****
out of the Celts in Civilization II!)

> -----Original Message-----
> From: Frank Yang [mailto:yang(--nospam--at)abam.com]
> Sent: Thursday, November 12, 1998 12:17 PM
> To: seaint(--nospam--at)seaint.org
> Subject: RE: Hey, All You MS Excel Gurus Out There...
>
>
> Bill,
>
> If you are using Excel 97, check out the conditional formatting.
>
> Select range C2:C14, select menu Format|Conditional
> Formatting..., change
> the condition to "Formula is" and type in the formula box
> =(C1=3).  Then
> select the format(s) you want to use, by clicking the
> "format..." button.
>
> I could e-mail you an example if you e-mail me privately.
> Hope this help
>
> Frank
>
> Frank Yang, P.E.
> Senior Engineer                                   BERGER/ABAM
> Engineers Inc
> Voice: 206-431-2374                                33301
> Ninth Avenue South
> Fax:   206-431-2250                             Federal Way,
> WA  98003-6395
> e-mail: yang(--nospam--at)abam.com
http://www.abam.com

-----Original Message-----
From: Bill Polhemus [mailto:polhemus(--nospam--at)insync.net]
Sent: Thursday, November 12, 1998 8:35 AM
To: seaint(--nospam--at)seaint.org
Subject: Hey, All You MS Excel Gurus Out There...


I could ask on a newsgroup, but you all are the biggest bunch o' Einsteins
I'M personally acquainted with.

I want to make the background shading of a cell contingent on the value of
the first cell in a column.  How can I do this (i.e. is there a formula that
affects shading?)

IOW:  Say I have a range C2:C14, and I want it to have either a white
(neutral, default) background, or a gray-shade, depending on the value of
cell C1.

Anyone have an idea?

Thanks!