Formatting a cell with a function (IF statement)
I have a matrix of values in sheet 1, and the cells in sheet 2 refer to sheet
1 with:
=IF('Sheet1'!A11400,"X"," ")
but instead of outputting an X in the cell in sheet 2, I would like the cell
to turn red if the corresponding cell in sheet 1 is 1400.
Help!
--
Cheerio
|