Conditional Formatting
 

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
.

.

Conditional Formatting
 

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
.

.

Conditional Formatting
 

So for 5 colours for 5 numbers would I have to specify
under true 5 times the colour refrence something like
this?

=if($C5 = 1, True then Red, False);=if($C5 = 2, True then
Orange, False);etc etc

Please give me more on how I would structure this for
conditional formatting for a row rather then just row in
a column

thanks again

-----Original Message-----
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
.

.


.

Conditional Formatting
 

For 5 colors you cannot use Conditional Formatting. Conditional
Formatting is limited to 3 colors (plus default). You can play with the
font with normal cell formatting in some cases but that would only be
for one cell. Read more about Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

But you will have to rethink about the 5 colors if you wand C.F.;
otherwise, you can use an Event macro. When you want to
color the entire row you use entirerow see an example
of a case statement.
http://www.mvps.org/dmcritchie/excel/event.htm#case
But that is basically the answer, you want to read the top
of that page as well.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ...
So for 5 colours for 5 numbers would I have to specify
under true 5 times the colour refrence something like
this?

=if($C5 = 1, True then Red, False);=if($C5 = 2, True then
Orange, False);etc etc

Please give me more on how I would structure this for
conditional formatting for a row rather then just row in
a column

thanks again

-----Original Message-----
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
.

.


.

Conditional Formatting
 

I have created another example for Event Change coloring,
this one will color the entire row based on the content of a column.
http://www.mvps.org/dmcritchie/excel/event.htm#case_row
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm