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