Changing cell colours

  • Thread starter Thread starter The Stoat
  • Start date Start date
T

The Stoat

Hi,

Does anyone know how to change the colour of text in one cell depending on
the value of another?

For example:

I want the word 'pig' in cell A1 to be red if the value of A2 is negative
I want the word 'pig' in cell A1 to be green if the value of A2 is positive.

Thanks for any help.

Matt.
 
What about if A2 is zero?

Use Format/Conditional Formatting...

CF1: Cell value is greater than 0
Format1: Font color green

CF2: Cell value is less than 0
Format2 Font color red
 
Back
Top