Sure it is possible. Darn near anything is possible, it is just that some
things are not worth doing. In this case it is fairly easy.

You need to use the formula option, not the cell option. select a single
cell and conditional format it with a formula that looks something like this:

=if($A1 100, True, False)

Once you get it just right you can copy it and pastespecial it as a format
for the rows you want.

The $ sign before the Column Letter is Critical. This will set the column
absolute. You do not want to set the row absolute or it will not copy down
rows correctly.

Hope this helps...

" wrote:

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
.

.