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