Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |