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!!!!


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)]
> Sent: Thursday, November 12, 1998 12:17 PM
> To: seaint(--nospam--at)
> 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)

-----Original Message-----
From: Bill Polhemus [mailto:polhemus(--nospam--at)]
Sent: Thursday, November 12, 1998 8:35 AM
To: seaint(--nospam--at)
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?