PC Review


Reply
Thread Tools Rate Thread

Conditional formating wiht complex formula

 
 
=?Utf-8?B?S2FyaW0=?=
Guest
Posts: n/a
 
      3rd Aug 2007
Hi,
I am trying to do the follwing in the simplest way:
if $H1>0, 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex Conditional Formating Ben A Microsoft Excel Worksheet Functions 6 16th Oct 2008 11:05 PM
Conditional Formating with a formula =?Utf-8?B?c3NjaWFycmlubw==?= Microsoft Excel Discussion 2 12th Mar 2007 04:58 PM
Conditional Formating Formula =?Utf-8?B?Um9i?= Microsoft Excel Misc 4 28th Nov 2006 01:55 PM
Complex logical/conditional formula =?Utf-8?B?QXNo?= Microsoft Excel Worksheet Functions 6 12th Jun 2006 11:04 PM
How do I do a complex conditional in a conditional formatting formula Ray Stevens Microsoft Excel Discussion 7 12th Mar 2006 10:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:31 AM.