Conditional formatting based on different sheets

[VoxBox-Richard]

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 T]

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

 

[Mike H]

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

 

[Bob Phillips]

=INDIRECT("Sheet2!A1")>10

as an example