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