 |
 | 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 / Worksheet Functions / February 2007Conditional Formatting based on entire column
Ok for any given row, I want to turn colums B:M green if columns L:M are not blank. In other words, when I enter something in any cell in columns L:M, I want those cells as well as the cells to the left of them to turn green (except A, but I could be flexible there if I had to) I've tried =NOT(ISBLANK($L:$M) on B:M and several other combinations but none work. I'm thinking I'm having trouble finding a formula that doesn't make Excel wait on the ENTIRE colums L:M be filled in. It needs to trigger only if the columns in a particular row are filled in. Does this make sense the way I've said it? What happens if you use =NOT(ISBLANK(L1:M1)) ? Dave  SignatureA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. > Ok for any given row, I want to turn colums B:M green if columns L:M > are not blank. In other words, when I enter something in any cell in [quoted text clipped - 9 lines] > > Does this make sense the way I've said it? Dave, That formula would 1) need to be array entered to work (which CF cannot handle) 2) would require L and M need to be $L and $M HTH, Bernie MS Excel MVP > What happens if you use =NOT(ISBLANK(L1:M1)) ? > [quoted text clipped - 13 lines] >> >> Does this make sense the way I've said it? Yes, you're right. Should have figured that one out! SignatureA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. > Dave, > [quoted text clipped - 24 lines] > >> > >> Does this make sense the way I've said it? Mike, Select B2:M2, then use Format / CF.... Formula is with the formula =AND($L2<>"",$M2<>"") Select you formatting, OK, OK, and then copy B2:M2 and paste special formats as far down the sheet as you need. HTH, Bernie MS Excel MVP > Ok for any given row, I want to turn colums B:M green if columns L:M > are not blank. In other words, when I enter something in any cell in [quoted text clipped - 9 lines] > > Does this make sense the way I've said it? It seems to me that you should select B:M for all desired rows, lets assume you start at row 2, and use a CF formula of =COUNTA($L2:$M2)<>0 Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Ok for any given row, I want to turn colums B:M green if columns L:M > are not blank. In other words, when I enter something in any cell in [quoted text clipped - 9 lines] > > Does this make sense the way I've said it? > It seems to me that you should select B:M for all desired rows, lets assume > you start at row 2, and use a CF formula of [quoted text clipped - 6 lines] > > Bob Instead of blocking all the cells I wanted the format to work on, I did it on one cell then copied down. Apparently I can't apply to all cells at once; I must apply to one cell then copy so the formula adjusts. It's working now. Thanks everyone. That is not so Mike. As long as the row is relative, you can apply to a block of rows, I do it all the time. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >> It seems to me that you should select B:M for all desired rows, lets >> assume [quoted text clipped - 16 lines] > > Thanks everyone. |
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.