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, |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com