software

Hi,

I want to be able to specify the colour of a cell depending on the
information in a different cell. Ie if the result is 7 or above the other
cell will be yellow, but if the result is above 14 the cell will become red.

any ideas?

Matt

In the cell you want conditionally formatted, Format gt; Conditional
Formatting. Set the condition to read 'Formula is' =$A$1gt;7 and set the
condition you want. (Substitute your 'different cell' where I put A1).

quot;mattguerillaquot; wrote:

gt;
gt; Hi,
gt;
gt; I want to be able to specify the colour of a cell depending on the
gt; information in a different cell. Ie if the result is 7 or above the other
gt; cell will be yellow, but if the result is above 14 the cell will become red.
gt;
gt; any ideas?
gt;
gt; Matt

I have done this already but the problem comes when the result is higher than
14. It should go red but it stays yellow. ???Matt

quot;bpeltzerquot; wrote:

gt; In the cell you want conditionally formatted, Format gt; Conditional
gt; Formatting. Set the condition to read 'Formula is' =$A$1gt;7 and set the
gt; condition you want. (Substitute your 'different cell' where I put A1).
gt;
gt; quot;mattguerillaquot; wrote:
gt;
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; I want to be able to specify the colour of a cell depending on the
gt; gt; information in a different cell. Ie if the result is 7 or above the other
gt; gt; cell will be yellow, but if the result is above 14 the cell will become red.
gt; gt;
gt; gt; any ideas?
gt; gt;
gt; gt; Matt

The format gets set by the first condition satisfied. So in your case, make
the test for gt;=14 (the more restrictive test) the first condition and the
test for gt;=7 the second.

quot;mattguerillaquot; wrote:

gt; I have done this already but the problem comes when the result is higher than
gt; 14. It should go red but it stays yellow. ???
gt;
gt;
gt; Matt
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; In the cell you want conditionally formatted, Format gt; Conditional
gt; gt; Formatting. Set the condition to read 'Formula is' =$A$1gt;7 and set the
gt; gt; condition you want. (Substitute your 'different cell' where I put A1).
gt; gt;
gt; gt; quot;mattguerillaquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I want to be able to specify the colour of a cell depending on the
gt; gt; gt; information in a different cell. Ie if the result is 7 or above the other
gt; gt; gt; cell will be yellow, but if the result is above 14 the cell will become red.
gt; gt; gt;
gt; gt; gt; any ideas?
gt; gt; gt;
gt; gt; gt; Matt