On Monday 09 January 2006 01:04, Dennis Marks wrote:
> I would like to have conditional formats for 81 different calc cells. When
> the cell above it contains an "S" then the cell will be red. I have set up
> a format and the condition is very easy to set up. The problem is that the
> same thing has to be done with 81 cells. Is there a quick way to do this?
Instead of conditional formatting, you could use the STYLE function within the
cell. e.g if the reference cell is A1 and therefore the cell to be coloured
is A2, then enter the following formula in cell A2:
=IF(A1="S";STYLE("red");STYLE("white"))
The STYLE function always returns 0, so can be added to existing formula
without affecting the result. It also means that the designated styles must
have leading zero's set to 0, if purely a coloured cell is required.
It is then easy to paste the formula into any number of cells.
HTH
Barrie
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
