Changing programmatically the color of a row

[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

 

[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