row 's background colour setup

[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)

 

[Dave Hawley]

Hi ALEX

Go to Format>Conditional Formatting. Post back with any specific
problems.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[ALEX]

THANKS DAVE

Thsis method can only change backgroud of that cell

but i want the whole raw's colour be changed

thanks for help

 

[Arvi Laanemets]

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

 

[Dave Hawley]

Hi Alex

Select say rows 1:100
Go to Format>Conditional Formating
Choose Formula is
Enter =$A1<0
Set Background Color
Ok and OK



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[alex]

ALEX wrote:
yes it did

thanks a lot !!!