Changing programmatically the color of a row

M

masterx81

Thanks for the answer!!!

And if i need to change the color of some rows on a sheet (more tha
100), when the value of a cell on the same row is < 0?

I've tryied the conditional formatting, but it need to be for ever
row! SIGH
 
F

Frank Kabel

Hi
why not use conditional format. Lets assume you want to change the color if
the value in column A <0. Try the following:
- select rows 1:100
- goto the conditional format dialog
- enter the following formula:
=$A1<0
- choose your format
 
Top