Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Dear experts,
I have account numbers in column A and I would like the account numbers in rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are highlighted in colour blue background. Is there a way to do this? If yes, how? Please kindly advise. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
First let's do this quick tinker ..
Put in any row1 cell, say in B1: =MOD(ROW(),14) Copy down to B28. You'd see that it returns a repeating series: 1,2,3,..13,0 where the zeros are exactly at the rows 14, 28, etc that you want CF'd (Clear col B) To effect the CF, just select the row headers for row 1-500, then apply the CF using Formula Is: =MOD(ROW(),14)=0 Format it to taste (blue fill), ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "Freshman" wrote: I have account numbers in column A and I would like the account numbers in rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are highlighted in colour blue background. Is there a way to do this? If yes, how? Please kindly advise. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi,
Highlight all the cells A1:A500, Choose Format, Conditional Formatting, from the first drop down pick Formula is, in the second drop down enter the formula =MOD($A1,14)=0 Click the Format button to the right and select the Patterns tab, pick a blue, click OK twice. -- Thanks, Shane Devenshire "Freshman" wrote: Dear experts, I have account numbers in column A and I would like the account numbers in rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are highlighted in colour blue background. Is there a way to do this? If yes, how? Please kindly advise. Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi Max,
You are great and the mentod works wonderful. Thanks again. Best regards to you and your family. "Max" wrote: First let's do this quick tinker .. Put in any row1 cell, say in B1: =MOD(ROW(),14) Copy down to B28. You'd see that it returns a repeating series: 1,2,3,..13,0 where the zeros are exactly at the rows 14, 28, etc that you want CF'd (Clear col B) To effect the CF, just select the row headers for row 1-500, then apply the CF using Formula Is: =MOD(ROW(),14)=0 Format it to taste (blue fill), ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "Freshman" wrote: I have account numbers in column A and I would like the account numbers in rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are highlighted in colour blue background. Is there a way to do this? If yes, how? Please kindly advise. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi Shane,
Thanks for your tip and it works wonderful. Thanks again. Best regards. "ShaneDevenshire" wrote: Hi, Highlight all the cells A1:A500, Choose Format, Conditional Formatting, from the first drop down pick Formula is, in the second drop down enter the formula =MOD($A1,14)=0 Click the Format button to the right and select the Patterns tab, pick a blue, click OK twice. -- Thanks, Shane Devenshire "Freshman" wrote: Dear experts, I have account numbers in column A and I would like the account numbers in rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are highlighted in colour blue background. Is there a way to do this? If yes, how? Please kindly advise. Thanks in advance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Welcome, glad it helped
Thanks for the thoughts -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "Freshman" wrote in message ... Hi Max, You are great and the mentod works wonderful. Thanks again. Best regards to you and your family. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |