View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karim Karim is offline
external usenet poster
 
Posts: 27
Default 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,