Changing programmatically the color of a row

  • Thread starter Thread starter masterx81
  • Start date Start date
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
 
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
 
Back
Top