Thread: highligthing every 28th cell help!
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default 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??
Reply With QuoteReply With Quote