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
.