row 's background colour setup

  • Thread starter Thread starter ALEX
  • Start date Start date
A

ALEX

dear all :

i want to setup up excel as follow:

if the value of a cell is less than zero,
then background colour of that row/column turns to blue

how can i do it?
thanks a lot

alex

--
Alex Fung
Best & Regards

Hong Kong Branch
Power Quotient International Co., Ltd.
Tel : 852-2707-4118
Fax : 852-2707-4308
E-Mail : (e-mail address removed)
 
THANKS DAVE

Thsis method can only change backgroud of that cell

but i want the whole raw's colour be changed

thanks for help
 
Hi

Select the whole row before selecting Conditional Format. 'Select Formula is
...' and enter the formula. P.e. for row 3 and A3 as comparision cell:
=($A3<0)
and select format for case TRUE.
After that you can copy this format to other rows, using
PasteSpecial.Formats
 
Back
Top