Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONDITIONAL FORMATING FORMULA | Excel Worksheet Functions | |||
Complex Conditional Formating | Excel Worksheet Functions | |||
IF formula with conditional formating help please | Excel Discussion (Misc queries) | |||
Conditional Formating Formula | Excel Discussion (Misc queries) | |||
Complex logical/conditional formula | Excel Worksheet Functions |