J Joe Sep 22, 2004 #1 I would like to be able to highlight a whole row if the value in column O is less than zero? Any ideas? Thanks
I would like to be able to highlight a whole row if the value in column O is less than zero? Any ideas? Thanks
F Frank abel Sep 22, 2004 #2 Hi for row 1 try: - select row 1 - goto the conditional formatting dialog - enter the formula: =$O1<0 - choose your format
Hi for row 1 try: - select row 1 - goto the conditional formatting dialog - enter the formula: =$O1<0 - choose your format
J Joe Sep 22, 2004 #3 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 . Click to expand...
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 . Click to expand...
