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]
Gary

Conditional formatting does work. However you have to be careful how you
type the condition.
The input is as follows

Cell value is ... equal to ... satisfactory

Do not enter the following :

Cell value is ... equal to ... "satisfactory"
or
Cell value is ... equal to ... ="satisfactory"

In this case it won't work.
(It took me quite some time to figure it out too)
After you have typed it in the correct way, EXCEL will automatically
translate it as follows :
Cell value is ... equal to ... ="satisfactory"

Hope this will help.

Stefan

-----Original Message-----
From: Gary Hodgson & Associates [mailto:ghodgson(--nospam--at)bellnet.ca] 
Sent: woensdag 12 april 2006 13:58
To: seaint(--nospam--at)seaint.org
Subject: RE: Simple Excel question.

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.
Gary



On 10 Apr 2006 at 8:44, Stefan Reumers wrote:

> Casey,
> 
>  
> 
> This is a small example of a range manipulation I use in one of my
> programms.
> 
> The cells are defined numerically (1,1) instead of using the address
> notation "A1"
> 
> In the example below, for example Cell (6,12) corresponds to Cell "L6"
> 
>  
> 
> For i = 1 To Nwind
> 
>     H = Worksheets("Cylinder").Cells(i + 5, 12).Value / 1000
> 
>  
> 
>     Select Case H
> 
>     Case Is < zmin
> 
>         vm = alfa1 * vref
> 
>         IV = beta1
> 
>     Case Else
> 
>         vm = alfa2 * vref * (H / 10) ^ expo
> 
>         IV = beta2 * (H / 10) ^ (-expo)
> 
>     End Select
> 
>     
> 
>     QB = ro / 2 * vm ^ 2 * (1 + 6 * IV)
> 
>     Worksheets("Cilinder").Cells(i + 5, 22).Value = QB
> 
> Next i
> 
>  
> 
> I hope this is helpful
> 
>  
> 
> Stefan
> 
> ________________________________
> 
> From: Casey K. Hemmatyar [mailto:khemmatyar(--nospam--at)gmail.com] 
> Sent: zaterdag 8 april 2006 00:23
> To: seaint(--nospam--at)seaint.org
> Subject: Simple Excel Visual Basic question.
> 
>  
> 
> I've got a Excel Visual Basic question.
> 
> I know how to write a simple program which can manipulate a single
cell
> 
> and the following shows it:
> 
>  
> 
> Sub test()
> 
> a = ActiveSheet.Range("thickness")
> 
> b = ActiveSheet.Range("length")
> 
> e = a * b
> 
> ActiveSheet.Range("force") = e * 10
> 
> End Sub
> 
>  
> 
> However I'd like to manipulate a "range" rather than a "cell". 
> 
> That means for instance I'd like to manipulate the "range" that
consists
> of A1, A2, A3 & A4 which can all in the same column or row. 
> 
> The reason for this is that I'd like to iterate a series of complex
> calculations.
> 
>  
> 
> I appreciate your input. 
> 
>  
> 
> Casey Hemmatyar, PE
> 
> Southern California
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> (Khashayar)
> 
> 



******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. 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: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ******** 

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. 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: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********