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??

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??

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??

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??

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??

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??

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??