Conditional formatting based on different sheets

How can I make a cell change colour based on and IF statement.

I want one cell to go red if the value in another cell is negative, but the
two cells are on different sheets so I canâ??t use conditional formatting.

Thank you.

Richard

Peter
Thu Jul 24 04:03:47 CDT 2008

Various ways, here are a couple

On the sheet you want to CF your cells, include a helper that simply refers
to your If formula on the other sheet

Name your If formula cell, eg "myIf"
then for your CF, Formula Is, =myIf=123

change the 123 as required, or simply =myIf if the formula evaluates to true
(eg a number)

Of course another way would be to replicate your If formula on the CF sheet

Regards,
Peter T


"VoxBox-Richard" <VoxBoxRichard@discussions.microsoft.com> wrote in message
news:69A5690D-228B-4B9B-98F9-066ABFFC3683@microsoft.com...
> How can I make a cell change colour based on and IF statement.
>
> I want one cell to go red if the value in another cell is negative, but
the
> two cells are on different sheets so I can't use conditional formatting.
>
> Thank you.
>
> Richard

MikeH
Thu Jul 24 04:16:03 CDT 2008

Hi,

You can cheat.

Enter your conditional format formula on the sheet you want it to apply to.
For example this in C1 of Sheet 1 looking at A1 of Sheet 4
=Sheet4!A1>6

Now in sheet 1 in the cell you want to conditional format, point to that cell
=$C$1=TRUE

Mike


"VoxBox-Richard" wrote:

> How can I make a cell change colour based on and IF statement.
>
> I want one cell to go red if the value in another cell is negative, but the
> two cells are on different sheets so I canâ??t use conditional formatting.
>
> Thank you.
>
> Richard

Bob
Thu Jul 24 04:56:04 CDT 2008

=INDIRECT("Sheet2!A1")>10

as an example

--
__________________________________
HTH

Bob

"VoxBox-Richard" <VoxBoxRichard@discussions.microsoft.com> wrote in message
news:69A5690D-228B-4B9B-98F9-066ABFFC3683@microsoft.com...
> How can I make a cell change colour based on and IF statement.
>
> I want one cell to go red if the value in another cell is negative, but
> the
> two cells are on different sheets so I can't use conditional formatting.
>
> Thank you.
>
> Richard