Conditional Formatting

  • Thread starter Thread starter ROPL
  • Start date Start date
R

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?
 
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
 
Back
Top