ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional formating wiht complex formula (https://www.excelbanter.com/excel-programming/394695-conditional-formating-wiht-complex-formula.html)

Karim

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