View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

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.