Changing cell colour depending on another cells value...

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

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.

--
Regards,
Dave


"Web master" wrote:

> 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
>
>
>

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

"Web master" wrote:

> 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
>
>
>

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

"Web master" wrote:

> 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
>
>
>