Need a book? Engineering books recommendations...

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

Re: Simple Excel question.

[Subject Prev][Subject Next][Thread Prev][Thread Next]
You're on the right track - that's the way I do it. What value are you using for your condition, a numeric or the string. Also, are you using the proper syntax with text -> ="ok" for OK? Are you trying to use "equal to" and a value of >1 (which it will probably "correct" to the text string ">1" behind your back)?

Gary Hodgson & Associates wrote:

This may be a no-brainer but there are days.  I want to
indicate a "satisfactory" answer in green and "no good"
in red. I tried conditional formatting but it doesn't
seem to work.  Can any body help me? TIA.

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
* * This email was sent to you via Structural Engineers * Association of Southern California (SEAOSC) server. To * subscribe (no fee) or UnSubscribe, please go to:
* Questions to seaint-ad(--nospam--at) Remember, any email you * send to the list is public domain and may be re-posted * without your permission. Make sure you visit our web * site at: ******* ****** ****** ****** ******* ****** ****** ********