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