| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
