Conditional formatting
Hi,
Can I not use references to cells in other work sheets while using Conditional Formatting? Thanks Big Boss |
I gave a cell a nice range name (Insert|Name) on that second sheet and I could
use it in a conditional formatting formula on the first sheet. Big Boss wrote: Hi, Can I not use references to cells in other work sheets while using Conditional Formatting? Thanks Big Boss -- Dave Peterson |
Can you please how exactly you did it? I tried but am not getting it.
Thanks Big Boss "Dave Peterson" wrote: I gave a cell a nice range name (Insert|Name) on that second sheet and I could use it in a conditional formatting formula on the first sheet. Big Boss wrote: Hi, Can I not use references to cells in other work sheets while using Conditional Formatting? Thanks Big Boss -- Dave Peterson |
I created a workbook with two worksheets (sheet1 and sheet2).
I selected A1 on sheet2 insert|name|define I gave it a nice name (test1) I selected B99 on sheet1 I did format|conditional formatting formula is: =b99=test1 and gave it a nice format. Big Boss wrote: Can you please how exactly you did it? I tried but am not getting it. Thanks Big Boss "Dave Peterson" wrote: I gave a cell a nice range name (Insert|Name) on that second sheet and I could use it in a conditional formatting formula on the first sheet. Big Boss wrote: Hi, Can I not use references to cells in other work sheets while using Conditional Formatting? Thanks Big Boss -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 04:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com