I need to get the whole row to conditionally format to
the colour depending on the number not just the row of
the column.

Is this possible?


-----Original Message-----
hi,
if you select the column, conditional format will apply
to
the entire column. otherwise conditional formating can
be
copied and pasted down a column. use paste all.

-----Original Message-----
I want to use conditional formatting to highlight
certain
comments made in diary worksheets.

The columns are formatted as follows -

Column 1 - Date
Column 2 - Description
Column 3 - Relevance

I would like to have the row colour coded depending on
the number entered in column 3.

I can use conditional formatting when I highlight and
select the menu but how can I code this into the
columns
to copy and paste again over many rows?

Rob
.

.