Home |
Search |
Today's Posts |
#8
![]() |
|||
|
|||
![]()
No problem! Thanks Sam!
Cheers! In article , "Sam via OfficeKB.com" 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
Conditional format problem | Excel Discussion (Misc queries) | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Copying a conditional format | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |