Conditional formating wiht complex formula
Hi,
I am trying to do the follwing in the simplest way:
if $H10, shade $A1 and go to next line, else stop
if $H1$A1, shade $B1 and go to next line, else stop
if $H1$A1+$B1 shade $C1 and go to next line, else stop
if $H1$A1+$B1+$C1 shade $D1 and go to next line, else stop
and so on€¦
of course there is no function called shade and I don't know how to
increment the column value
I am hoping to use this to examine 500 rows of data
Any suggestions?
Thanks,
|