Greetings,
I used conditional formatting along with formulas in excel to color rows differently when a change in the name occurs in column C.
1. conditional formatting: format values where this formula is true
=$T2=0
2. In my helper column T, I used the following formula:
=MOD(IF(ROW()=2,0,IF(C2=C1,T1,T1+1)),2)
It works as intended. But, I would like to enhance the formula to avoid getting #REF when filling down the formula to blank fields.
=MOD(IF(ROW()=2,0,IF(C14=#REF!,#REF!,#REF!+1)),2)
My template has 50 rows, and if nothing entered in the remaining cells, I would like my helper column to show blank instead of #REF!
TIA,
Regards,
OCM