Conditional Formatting

[ROPL]

I have a spreadsheet which I need to have conditional formatting. It is excel
2003 but is only allows me to have a 3 conditions / colour.

1st conditions I want, if it reads January, Feb or March change field to
yellow

2nd condition I want, if it ready April change field to green.

On the first condition, how do I write the formular?

 

[WLMPilot]

In the Conditional Format window, change the first box to "Formula Is"

In the next box, copy/paste the following:

=AND(A1<>"", OR(A1="January",A1="February",A1="March"))


Les

 

[Jarek Kujawa]

=OR(A1="January",A1="February",A1="March")