Conditional Formatting
 

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?

--
K

Conditional Formatting
 

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

"ROPL" wrote:

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?

--
K

Conditional Formatting
 

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


On 23 Kwi, 14:09, ROPL wrote:
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?

--
K