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]
Use the Conditional Formatting feature on the Format drop down menu. I'm not
sure what version they introduced it, but it is in My excel 97 package.
You create a conditional statement or a number of them (depending upon the
levels you establish) to shade the cell based upon the conditions
established. For example, in a Shearwall analysis, I have the cell turn red
if the condition is such that the shear exceeds maximum plywood capacity,
H/b ratio or even if the cell reflects a 3x plate if the shear in the panel
exceeds 300 plf.
This should do the trick.
Dennis Wish PE

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