Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
condition formating
I have more than 50 columns, how I can make each column condition is column
dependent ? instead do column by column. I try use the paste special , it doesn't work, it just copy all formula over from the first column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
condition formating
Hi sb,
If I understand correctly, make sure your initial formula does not contain absolute references, and then just make a normal copy-paste ... HTH Cheers Carim sb wrote: I have more than 50 columns, how I can make each column condition is column dependent ? instead do column by column. I try use the paste special , it doesn't work, it just copy all formula over from the first column. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
condition formating
You can do it by selecting all the data at the start, before setting up the
CF. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "sb" wrote in message ... I have more than 50 columns, how I can make each column condition is column dependent ? instead do column by column. I try use the paste special , it doesn't work, it just copy all formula over from the first column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating Problem | Excel Discussion (Misc queries) | |||
Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
condition formating I think | Excel Discussion (Misc queries) | |||
condition formating | Excel Worksheet Functions | |||
Conditional Formating | Excel Discussion (Misc queries) |