 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004Conditional Formatting
Hi all I have this conditional format in cell BB35 =IF(BB35>$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35>$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? Many thanks  SignatureGeorge Gee -- Select cell B35 Choose Format>Conditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35>INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK > I have this conditional format in cell BB35 > =IF(BB35>$BB$37,TRUE) [quoted text clipped - 4 lines] > Is there a way of making BB37 absolute, > or is there a formula using ROW that I could use? SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html The formula should be: =BB35>INDIRECT("BB37") > Select cell B35 > Choose Format>Conditional Formatting [quoted text clipped - 11 lines] >> Is there a way of making BB37 absolute, >> or is there a formula using ROW that I could use? SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Debra Yes, I did have the sense to alter that! Many thanks George Gee *Debra Dalgleish* has posted this message: > The formula should be: =BB35>INDIRECT("BB37") > [quoted text clipped - 18 lines] > Excel FAQ, Tips & Book List > http://www.contextures.com/tiptech.html You're welcome, and I'm glad you're more awake than I am! > Debra > [quoted text clipped - 28 lines] >>Excel FAQ, Tips & Book List >>http://www.contextures.com/tiptech.html SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Debra Spot on! Many thanks George Gee *Debra Dalgleish* has posted this message: > Select cell B35 > Choose Format>Conditional Formatting [quoted text clipped - 16 lines] > Excel FAQ, Tips & Book List > http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.