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
|