| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highligthing every 28th cell help!
i am trying to highlight every 28th cell so it can be filled so eg start by
filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.?
Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
hi Stefi
thats correct any advice? "Stefi" wrote: Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.? Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
Select column D, FormatConditional formattingChoose formula as
conditionEnter =MOD(ROW()-4,28)=0 in formula fieldSelect a patternOK Regards, Stefi €žady€ť ezt Ă*rta: hi Stefi thats correct any advice? "Stefi" wrote: Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.? Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
tHANK YOU SO MUCH WILL HAVE A MESS AROUND WITH IT IS IT OK TO GET BACK TO YOU
IF I HAVE ANY PROBS ?IT MAY NOT BE TODAY THOUGH tHANKS "Stefi" wrote: Select column D, FormatConditional formattingChoose formula as conditionEnter =MOD(ROW()-4,28)=0 in formula fieldSelect a patternOK Regards, Stefi €žady€ť ezt Ă*rta: hi Stefi thats correct any advice? "Stefi" wrote: Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.? Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
You are welcome! Thanks for the feedback! Just post your questions any time
in this forum, there are several helpers ready to help you. Stefi €žady€ť ezt Ă*rta: tHANK YOU SO MUCH WILL HAVE A MESS AROUND WITH IT IS IT OK TO GET BACK TO YOU IF I HAVE ANY PROBS ?IT MAY NOT BE TODAY THOUGH tHANKS "Stefi" wrote: Select column D, FormatConditional formattingChoose formula as conditionEnter =MOD(ROW()-4,28)=0 in formula fieldSelect a patternOK Regards, Stefi €žady€ť ezt Ă*rta: hi Stefi thats correct any advice? "Stefi" wrote: Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.? Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highligthing every 28th cell help!
And fix your caps lock key.
Regards, Fred "ady" wrote in message ... tHANK YOU SO MUCH WILL HAVE A MESS AROUND WITH IT IS IT OK TO GET BACK TO YOU IF I HAVE ANY PROBS ?IT MAY NOT BE TODAY THOUGH tHANKS "Stefi" wrote: Select column D, FormatConditional formattingChoose formula as conditionEnter =MOD(ROW()-4,28)=0 in formula fieldSelect a patternOK Regards, Stefi €žady€ť ezt Ă*rta: hi Stefi thats correct any advice? "Stefi" wrote: Do you mean that 1st cell to be highlighted is D4, next is D32, then D60, etc.? Stefi €žady€ť ezt Ă*rta: i am trying to highlight every 28th cell so it can be filled so eg start by filling cell4d then want to automactically highlight and fill every 28th blank cell in my table can this be done?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| "DAYS 360" and the date Feb 28th as start and end | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
