In cell E5 I have the following conditional format formula that I will drag down to E53. I need help revising it so that checks if the condition is true in cell P59, AO59, BN 59 ect..
Can anyone help with this?
=INDIRECT("$59"&COLUMN(A1)*25+16)>=$O$4
Last edited by rhudgins; 08-17-2010 at 09:53 AM.
I might be wrong but given the values in E4:E53 equate to the % values of P59, AO59 etc already you can simply use the contents and compare to O4, no ?
With E4:E53 selected rule applied is:
=$E4>=$O$4
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That would work but I am going to add more complicated rules so I need it in my initial format. Are you familar with how to revise it?
Well I confess I don't understand how additional rules changes things (at all) but to answer your question - just replicate the INDEX you've used already in E4:E53
Please Login or Register to view this content.
The reason why it gets more complicated is because in the range E4:E53 I also need to add the following conditional format formula. I want to be able to have one formula that I can drag down the range E4:E53 so that I can avoid having the type out the following formulas multiple times. Is this clear? Thanks
In E4..
=(AND(Q59>$O$4,(Q59-O59)>$O$3))
In E5...
=(AND(AQ59>$O$4,(AQ59-AO59)>$O$3))
In E6..
=(AND(BP59>$O$4,(BP59-BN59)>$O$3))
ect...
Yes and no.
I understand the logic but the ranges in your latest post are inconsistent.
For ex. previously you mentioned P, AO, BN etc with a consistent step of 25 - now you mention Q, AQ, BP which has an inconsistent step.
Did you perhaps mean either of Q, AP & BO or Q, AQ & BQ (with O, AO & BO for subtraction) ?
For the sake of demo. assuming you meant Q, AQ & BQ (step of 26) then:
If the steps are inconsistent then things become convoluted.Please Login or Register to view this content.
Thanks for all of your help I figured it out. Enjoy your day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks