Conditional formatting

[Nitro2481]

Hey Guys,

I'm stuck using 2003. Job won't upgrade. As a result I only can have 3 conditions for for conditional formatting. I have for example
if Cell a1 = 1 then go green
if Cell a1 = 2 then go orange
if Cell a1 = 3 then go red

Is there a formula like the if function that says =if(or(a1=1,a1=0),Go green Basically get 2 for 1?

[dflak]

It's been ages since I've used 2003.

First of all reverse the logic.
A1 >= 3 (Red)
A1 >= 2 (Orange)
A1 >= 0 (Green)

Or I still think you can use the Use formula option.

[Nitro2481]

Sorry bad example on my part. Instead of numbers it's words
A1 = not proceeding (red)
A1 = in progress (orange)
A1 = started or A1 = completed (green)
For example.

[dflak]

I think you can still use the formula option.

=A1 = "NOT Proceeding" -> Red
=A1 = "In Progress" -> Orange
=OR (A1 = "Started", A1 = "Completed") -> Green

[Tony Valko]

Try this...

Goto the menu Format>Conditional Formatting

Select the Formula Is option

Enter this formula in the box on the right:

=A1="not proceeding"

Click the Format button
Select the desired style(s)

Click the Add button

Select the Formula Is option

Enter this formula in the box on the right:

=A1="in progress"

Click the Format button
Select the desired style(s)

Click the Add button

Select the Formula Is option

Enter this formula in the box on the right:

=OR(A1="started",A1="completed")

Click the Format button
Select the desired style(s)
OK out

[Nitro2481]

Thanks a mil guys but I'm getting an error on the last formula saying that "you may not use unions, intersections, or array constants for conditional formatting criteria". Looks as though it cannot be done.

[Nitro2481]

Just FYI

I found a workaround. I set up a new column saying if(or(A1="started",A1="completed"),"yes,"")

And changed the conditional format to
a1=not progressing (red)
a1=inprogress (orange)
b1=Yes (green) which will work for both started and completed.

[Tony Valko]

Thanks a mil guys but I'm getting an error on the last formula saying that "you may not use unions, intersections, or array constants for conditional formatting criteria". Looks as though it cannot be done.

=OR(A1="started",A1="completed")

Works just fine for me in all the versions of Excel I have including Excel 2002.

You will get that message if you try using the formula like this:

=OR(A1={"started","completed"})

[Nitro2481]

I typed it exactly as you suggested. Definitely didn't use the funny brackets.