Conditional Formating - Highlighting a entire row

[Joe]

I would like to be able to highlight a whole row if the
value in column O is less than zero? Any ideas?

Thanks

 

[Frank abel]

Hi
for row 1 try:
- select row 1
- goto the conditional formatting dialog
- enter the formula:
=$O1<0
- choose your format

 

[Joe]

Worked like a charm. thanks a ton

-----Original Message-----
Hi
for row 1 try:
- select row 1
- goto the conditional formatting dialog
- enter the formula:
=$O1<0
- choose your format

.