formatting with multiple conditions

[Rolly]

I have an excel sheet in which I would like to format rows (give them
colored background) based on the value of one cell in each row. Thi
cell is always in the same column.

Now, to be more specific. I want that row to change color when a dat
in the form of mm/dd/yy or mm/dd is entered. It could be any date. Th
problem is, I have frozen the panes in the sheet, and two cells at th
head of the column will not include dates. One is empty and gray (and
want it to stay gray). The other has the text "In-stock" and alway
will. I don't want these cells or their rows to change color like th
rest of the document.

So, how could I do this using conditional formatting? A forumula lik
=$N1>0 doesn't work because of the text heading the column. Is there
way to enter multiple conditions, such as =$N1>0 AND $N1 <> "In-stock"


Thanks for your help

 

[Frank Kabel]

Hi
enter the following formula in the conditional format dialog
=AND($N1>0,$N1 <> "In-stock")

 

[Rolly]

Works like a charm