Re: Conditional Format - Formula to Colour Every 3rd Cell in Offset Range

No problem! Thanks Sam!

Cheers!

In article <52C2668A895DD@xxxxxxxxxxxx>,
"Sam via OfficeKB.com" <forum@xxxxxxxxxxxx> wrote:

> Hi Domenic,
>
> You're right, it doesn't work. My eyes and memory are playing tricks on me! I
> was sure I deleted the Formula in Column I19 down and the number 3 remained
> by using only the Formula below in the Conditional Formatting Is Formula:
>
> =IF((ROWS(I$19:I19)<=ROWS(Position))*(MOD(ROW()-ROW(I$19)+1,3)=0),3,"")
>
> But it doesn't work. Everything stands as it did in your original (first)
> reply. I'm going to put this one down to sleep deprivation. I don't know
> what I was looking at! Apologies for mix up.
.

Relevant Pages

  • Re: Lets get to the real beef of the Verbier Festival for once.
    ... One of the violinists playing was "infected" with them. ... was visibly annoyed while recording this section of the concert. ... Sam, not playing (would later play piano a Schubert Piano quintet - the ...
    (rec.music.classical.recordings)
  • [HPADM] SUMMARY Kernel parameter names and suggested values
    ... Thanks for all the replys here was the original question.I made the changes through SAM and all is well. ... We have an application that is using a lot of memory. ... For most of them I can just put in the number, but when I get to maxDsiz, maxTsiz, and maxSsiz I think I will have to put in their hex value??? ...
    (HP-UX-Admin)
  • Re: Memory
    ... the memory is perfect. ... the eyes at once ... An imperfect memory or an imperfect imagination may produce organic ... Mental pictures are imagined perfectly when the memory is perfect. ...
    (sci.med.vision)
  • Re: OT: conversations about life
    ... eyes, why not the witnesses? ... their visual memory can deceive them, filling in gaps in the memory etc. ... the actual bag snatcher. ... witnesses do better. ...
    (alt.support.diabetes)
  • Re: nuts & bolts issues
    ... what do you do about eyes that are glued to the keyboard. ... Harpo Marx's piano playing comes ...
    (rec.music.makers.piano)