Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
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
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
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 --- 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 ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | 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 |