Is this possible with Conditional Formatting, or would I have to write it in
VBA? (I can't guarantee the end user will enable the macro).

For a specified range
If the cell is empty, no formatting
If the cell equals "SAT" or "NI" then set background as green
If the cell equals "UNSAT" or UNACC" then set background as red.

Say your range was A1:A10
Select the range, with the focus in A1, then:

<Format <ConditionalFormat,
Click "Formula Is", and enter this:

=OR(A1="Sat",A1="Ni")

Click of <Format, and choose you pattern color, then <OK,

Then click on <Add for your second condition,
Click "Formula Is", and enter this:

=OR(A1="UnSat",A1="UnAcc")

Click of <Format, and choose you second pattern color, then <OK <OK

--
HTH,

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


"StephanieH" wrote in message
...
Is this possible with Conditional Formatting, or would I have to write it
in
VBA? (I can't guarantee the end user will enable the macro).

For a specified range
If the cell is empty, no formatting
If the cell equals "SAT" or "NI" then set background as green
If the cell equals "UNSAT" or UNACC" then set background as red.

Because your entries for green and red each fall together within the
alphabet, yo can set condition one as Cell value is between Sat and NI and
condition 2 as Cell value is between Unacc and Unsat


"StephanieH" wrote:

Is this possible with Conditional Formatting, or would I have to write it in
VBA? (I can't guarantee the end user will enable the macro).

For a specified range
If the cell is empty, no formatting
If the cell equals "SAT" or "NI" then set background as green
If the cell equals "UNSAT" or UNACC" then set background as red.