Condintional Formatting

[jschmeling2000]

Under Condition 1 only, how can I have the cell turn colors if the cel
is equal to B-,B,B+,A-,A,A+.

Thanks,
Jo

 

[RagDyeR]

Try this,

Click "Formula Is", and enter:

=OR(A1="A+",A1="A",A1="A-",A1="B+",A1="B",A1="B-")

And then choose your formats.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message Under Condition 1 only, how can I have the cell turn colors if the cell
is equal to B-,B,B+,A-,A,A+.

Thanks,
Jon

 

[Alfred Dearnley]

Hi!

Try >="C-" as your condition.
This assumes you have no cells with values whose ASCII codes are less than
A's (like 0-9).

Alf
message | Under Condition 1 only, how can I have the cell turn colors if the cell
| is equal to B-,B,B+,A-,A,A+.
|
| Thanks,
| Jon
|
|
| ---
| Message posted
|

 

[jschmeling2000]

Thanks! That works