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