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