Conditional Formatting Problem

Below is an example spreadsheet that I�m dealing with. I have a column with
�Standards� (more on that later), but I have my results in three possible
�formats�

�Standard� Result 1 Result 2 Result 3
0.01 0.123 0.123J <0.123
1.0 0.123 0.123J <0.123

First, I want to create a conditional format that will BOLD only the cells
that have just numbers in them (i.e. 0.123), and leave the other two types
alone.

Second, I will be comparing the cells with only numbers in them (i.e. Result
1) to the Standard and highlighting only those values that are greater to or
equal to the Standard. In the example above, the upper Result 1 value would
not be highlighted while the lower Result 1 value would be.

Any ideas?

TxAg,

For the first requirement, select the three Result columns. Format -
Conditional formatting - Formula is:

=ISNUMBER(B2)

This presumes the active (white) cell of your selection is B2. Change as
necessary. Usually row 1 has headings.

For the second requirement, you don't say what you mean by "highlight," or
how that relates to the first requirement. If you want cells that contain
only a number (as with the first requirement), and also are greater than the
corresponding cell in column A, the conditional formatting formula is:

=AND(ISNUMBER(B2), B2>=$A2)

--
Earl Kiosterud
www.smokeylake.com

"TxAg" <[email protected]> wrote in message
news:[email protected]...
> Below is an example spreadsheet that I'm dealing with. I have a column
> with
> "Standards" (more on that later), but I have my results in three possible
> 'formats'
>
> "Standard" Result 1 Result 2 Result 3
> 0.01 0.123 0.123J <0.123
> 1.0 0.123 0.123J <0.123
>
> First, I want to create a conditional format that will BOLD only the cells
> that have just numbers in them (i.e. 0.123), and leave the other two types
> alone.
>
> Second, I will be comparing the cells with only numbers in them (i.e.
> Result
> 1) to the Standard and highlighting only those values that are greater to
> or
> equal to the Standard. In the example above, the upper Result 1 value
> would
> not be highlighted while the lower Result 1 value would be.
>
> Any ideas?

Earl,
Thanks for the help. It worked just fine.


"TxAg" wrote:

> Below is an example spreadsheet that I’m dealing with. I have a column with
> “Standards” (more on that later), but I have my results in three possible
> ‘formats’
>
> “Standard” Result 1 Result 2 Result 3
> 0.01 0.123 0.123J <0.123
> 1.0 0.123 0.123J <0.123
>
> First, I want to create a conditional format that will BOLD only the cells
> that have just numbers in them (i.e. 0.123), and leave the other two types
> alone.
>
> Second, I will be comparing the cells with only numbers in them (i.e. Result
> 1) to the Standard and highlighting only those values that are greater to or
> equal to the Standard. In the example above, the upper Result 1 value would
> not be highlighted while the lower Result 1 value would be.
>
> Any ideas?