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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Macro to automatically go to the right of the last colored cell 0
How to filter rows data based on background color of individual cells 1
Changing programmatically the color of a row 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top