Changing cell colour depending on another cells value...

[Web master]

Hello all,

Just curious if this is possible... can i have an equation (or something)
that shades a cell a specific colour dependant on a condition of another
cell? For example, if I want cell B5 shaded green if cell A1 is a positive
number; if cell A1 was a negative number, i would want cell B5 shaded red.

Let me know your thoughts,

Ian

 

[Guest]

Conditional formatting: <Format><Conditional Formatting>

Choose 'Formula Is' and enter =A1>0 and make the formatting green. Then add
another condition, choose 'Formula Is' again, and enter =A1<0, and make the
formatting red.

 

[Guest]

Under "Format" there is the option "Conditional Formating" that is the
function that shades cell according to your specifications.

 

[Guest]

I hope you dont mind me adding my question but when the cell changes to a
specific colour say a12 goes red (a12 is a date an assessment is due) when a
date is within 30 days can a12 and a1 (which a name is in a1) be put on a
different worksheet (say sheet2) and the same for each row that the colour
appears so i can have a list of names and assessments on a seperate worksheet
to print off

there are 8 assessments along a row and about 40 names in a column

thanks