At 15:54 28/05/2008 +0800, Bashar Maree wrote:
Is there a way to control the background color of a cell according
to a formula. For example if the value in the cell is over 7 make
the background red, if less make it green and so on.
o Go to Format | Styles and Formatting (or use the button in the
Formatting toolbar or press F11).
o Create separate cell styles for each colour you require, setting
the background colour on the Background tab.
o Select the relevant cells.
o Go to Format | Conditional Formatting... and set the required
conditions to apply your cells styles according to the values of the cells.
If you need more colours that the conditions will allow, remember
that you could set one background colour to the cells manually and
have the others applied as conditional formatting.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
