software

Hi everyone, I would like to use conditional formatting on a table that is 8
columns wide and 50 rows high.

What I would like to do is colour all rows that have an X in column D or E.

This is what I tried The formula is =A1=quot;xquot;
This colours only the cells where there is an X. What I would like is the
entire row or rows to be coloured.

Thanks for your efforts

Gilles
Try setting to The formula is =OR($D1=quot;Xquot;,$E1=quot;Xquot;)
The mixed reference will allow you to copy this to your entire table,
keeping the references fixed to column D or E of the current row.

quot;Gilles Desjardinsquot; wrote:

gt; Hi everyone, I would like to use conditional formatting on a table that is 8
gt; columns wide and 50 rows high.
gt;
gt; What I would like to do is colour all rows that have an X in column D or E.
gt;
gt; This is what I tried The formula is =A1=quot;xquot;
gt; This colours only the cells where there is an X. What I would like is the
gt; entire row or rows to be coloured.
gt;
gt; Thanks for your efforts
gt;
gt; Gilles
gt;
gt;
gt;

Thank You, worked like expected.

Gilles
quot;bpeltzerquot; gt; wrote in message
...
gt; Try setting to The formula is =OR($D1=quot;Xquot;,$E1=quot;Xquot;)
gt; The mixed reference will allow you to copy this to your entire table,
gt; keeping the references fixed to column D or E of the current row.
gt;
gt; quot;Gilles Desjardinsquot; wrote:
gt;
gt;gt; Hi everyone, I would like to use conditional formatting on a table that
gt;gt; is 8
gt;gt; columns wide and 50 rows high.
gt;gt;
gt;gt; What I would like to do is colour all rows that have an X in column D or
gt;gt; E.
gt;gt;
gt;gt; This is what I tried The formula is =A1=quot;xquot;
gt;gt; This colours only the cells where there is an X. What I would like is the
gt;gt; entire row or rows to be coloured.
gt;gt;
gt;gt; Thanks for your efforts
gt;gt;
gt;gt; Gilles
gt;gt;
gt;gt;
gt;gt;