software

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: lt;Formatgt;lt;Conditional Formattinggt;

Choose 'Formula Is' and enter =A1gt;0 and make the formatting green. Then add
another condition, choose 'Formula Is' again, and enter =A1lt;0, and make the
formatting red.

--
Regards,
Davequot;Web masterquot; wrote:

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

Under quot;Formatquot; there is the option quot;Conditional Formatingquot; that is the
function that shades cell according to your specifications.

quot;Web masterquot; wrote:

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

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

quot;Web masterquot; wrote:

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