quincy
Joined: 30 Jun 2005
Posts: 216
|
 Posted: 06/04/07 - 05:25 Post subject: |
 |
|
| When I use drag&drop function, conditional formatting wont work. There are two cells. Each one of them uses the same formula. Trick is to use conditional formatting on 2 or 3 cell s at the same time. How to achieve this in one shot? Actually, I succeeded in formatting one cell, btu I wont repeat that process all the time. Other cell wont respond to my orders, is there a plug-in which can allow me to do this? Thanks! |
|
jephthah
Joined: 10 Sep 2005
Posts: 205
|
| Posted: 07/06/07 - 03:07 Post subject: |
|
|
| Select all your cells and apply only one formula. If that works, go to tools menu, and select multiple selections. I am not sure exactly in what menu is, but look for it. There is a format painter tool, for multiple format purpose. What are to accomplish with one shot. Try to paint each cell which contains formatting. Use different colors for each formula. You need a method to distinguish which cell contains formatting. Excel has an ISBLANK functions for testing. Each entry is not a formula, so remember this when you are working with multiple functions. OF course, you can always use macro, if you know how. Its the far better option then other embedded functions. You can also make your own macro. Select all your actions, and save macro for later use. Type the conditions in appropriate field, and save settings. |
|
