Conditional formatting

[Rob]

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

 

[Guest]

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.

 

[David McRitchie]

I guess that can be interpreted two ways but I think the original poster
meant for the entire row to be colored based on the value in Column C.
Of course there was no detail for the what values would get a color.

If it was only Column C to receive color, then only select C and the
formulas rest of the instructions below still apply word for word.

Code the Column as $C instead of C so that each cell in a row
will see the value in column C rather than relative to itself as the column
it appears in.

Suggest looking at my page
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Select C1 then Ctrl+A (to select the entire sheet)

C.F. Condition 1: =$C1 > 100
C.F. Condition 2: =$C1 > 50
C.F Condition 3: =$C1 > 25

You are limited to 3 C.F. formulas per cell, so if you
need more you would need to use an Event Macro
http://www.mvps.org/dmcritchie/excel/event.htm#case