Conditional formatating

  • Thread starter Thread starter Sverre
  • Start date Start date
S

Sverre

Can anybody help me with a VB-program do do this ?

I have a large daatasheet with integer. After each group of data the average
is calculated and the results are introduced as decimals which starts from
column B to U.
I do want to have a yellow backgrund colour from A to U in this row with
the averages. How can I do that in VB.

An anoter option is to give all cells containing decimal digits in the
entire sheet a yellow background.
 
If lngRow is the row number, the below code set the color index frm A to U

Range("A" & lngRow & ":U" & lngRow).Interior.ColorIndex = 6

If this post helps click Yes
 
Sorry that did not solve the task. The whole sheet was coloured yellow.
I want to have a yellow row if the rows cintaining decimal digit.

Jacob Skaria skrev:
 
I have only answered the first part of your question

The below code with lngRow = 1 will set the first row A1:U1 to yellow.

Range("A" & lngRow & ":U" & lngRow).Interior.ColorIndex = 6
 

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

Conditinal formatating 1
Conditional Formatting and VBA 4
conditional formatting 2
Word Conditional Formatting in Word 0
Insert a text in Column A and calculate the average from column B 7
Insert text in column A and calculate the average from column B 4
Setting conditional colours for cells 2
Conditional Formatted Colored Cells 1

Back
Top