Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting on a cell range
Hi. I'm applying conditional formatting to a column (B) based on another column (A). Data exists in both columns. Here is how I'm doing it now. 1) copy all data in B to another column C 2) select cell B1 and apply CF referencing $A1 3) drag cell B1 and copy down to bottom of column (about 2000 values) in order to automatically increment cell reference to reference adjacent cell (B1 to A1, B2 to A2, etc). But all values are now the same as A1. 4) copy column C into column B, copying only values such that the CFs are preserved and values are restored. 5) delete column C I'm sure there's a better way. Could you tell me what it is? Thank you! -- mdchachi ------------------------------------------------------------------------ mdchachi's Profile: http://www.excelforum.com/member.php...o&userid=33953 View this thread: http://www.excelforum.com/showthread...hreadid=537280 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting on a cell range
You don't have to mave dta around. Do Conditional Formatting in say A1. Now
click on the Format Painter icon (The paintbrush), click and hold the mouse button on the first cell you want to copy to, drag to the last cell and release. Conditional formatting is applied to the range. "mdchachi" wrote: Hi. I'm applying conditional formatting to a column (B) based on another column (A). Data exists in both columns. Here is how I'm doing it now. 1) copy all data in B to another column C 2) select cell B1 and apply CF referencing $A1 3) drag cell B1 and copy down to bottom of column (about 2000 values) in order to automatically increment cell reference to reference adjacent cell (B1 to A1, B2 to A2, etc). But all values are now the same as A1. 4) copy column C into column B, copying only values such that the CFs are preserved and values are restored. 5) delete column C I'm sure there's a better way. Could you tell me what it is? Thank you! -- mdchachi ------------------------------------------------------------------------ mdchachi's Profile: http://www.excelforum.com/member.php...o&userid=33953 View this thread: http://www.excelforum.com/showthread...hreadid=537280 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting on a cell range
You can also select your range in column B and write the formula for the
activecell. Excel will adjust the formula for the other cells in the selected area. mdchachi wrote: Hi. I'm applying conditional formatting to a column (B) based on another column (A). Data exists in both columns. Here is how I'm doing it now. 1) copy all data in B to another column C 2) select cell B1 and apply CF referencing $A1 3) drag cell B1 and copy down to bottom of column (about 2000 values) in order to automatically increment cell reference to reference adjacent cell (B1 to A1, B2 to A2, etc). But all values are now the same as A1. 4) copy column C into column B, copying only values such that the CFs are preserved and values are restored. 5) delete column C I'm sure there's a better way. Could you tell me what it is? Thank you! -- mdchachi ------------------------------------------------------------------------ mdchachi's Profile: http://www.excelforum.com/member.php...o&userid=33953 View this thread: http://www.excelforum.com/showthread...hreadid=537280 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting on a cell range
Ah, I knew there must be an easier way. Thanks to both of you. -- mdchachi ------------------------------------------------------------------------ mdchachi's Profile: http://www.excelforum.com/member.php...o&userid=33953 View this thread: http://www.excelforum.com/showthread...hreadid=537280 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting depending a range of cell | Excel Worksheet Functions | |||
Conditional Formatting & Dynamic Range | Excel Worksheet Functions | |||
Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |