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 cant 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" wrote in message
...
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!A16

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 cant use conditional formatting.

Thank you.

Richard

=INDIRECT("Sheet2!A1")10

as an example

--
__________________________________
HTH

Bob

"VoxBox-Richard" wrote in message
...
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