| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatating
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatating
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 --------------- Jacob Skaria "Sverre" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatating
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: 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 --------------- Jacob Skaria "Sverre" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatating
I have only answered the first part of your question
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. The below code with lngRow = 1 will set the first row A1:U1 to yellow. Range("A" & lngRow & ":U" & lngRow).Interior.ColorIndex = 6 -- If this post helps click Yes --------------- Jacob Skaria "Sverre" wrote: 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: 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 --------------- Jacob Skaria "Sverre" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditinal formatating | Excel Programming | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
Linear Mode
