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

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" <(E-Mail Removed)> wrote in message
news:69A5690D-228B-4B9B-98F9-(E-Mail Removed)...
> 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

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

=INDIRECT("Sheet2!A1")>10

as an example

--
__________________________________
HTH

Bob

"VoxBox-Richard" <(E-Mail Removed)> wrote in message
news:69A5690D-228B-4B9B-98F9-(E-Mail Removed)...
> 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