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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Help with date formula and colour change 3
Cell colour change if formula displays false 3
Copying formatting 1
Excel formula, sum the value cell and if empty cell left blank 0
Changing cell colour depending on another cells value... 3
Count Interior Colour 7

Back
Top