Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good to hear that ! Thanks for posting your findings.
Yes, like in life itself, those dollar signs can really make a crucial difference <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "KC Rippstein hotmail com" <kcrippstein<atdot wrote in message ... I just figured it out. Simply put a dollar sign in front of the second A. Instead of =MOD(SUBTOTAL(3,$A$1:A1),2)=0 use =MOD(SUBTOTAL(3,$A$1:$A1),2)=0 All we really care about is the counta from column A, so that can stay fixed. YES!! - KC Rippstein |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional formating -identify blank cell | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) |