Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a conditional formating rows with text and values
I have a list of text and values i.e A5:M5 and 200 rows beneath. I
highlighted A5:M5CFNew ruleUse a formula to determine which cells to format =$A$5=10%Format color yellowok. When A5 is + 10% the A5:M5 will be automatically yellow, but when I want to copy this format to the beneath rows it will change all the original text and values. Is there any rule to copy this conditional formating to following rows that original text and values don't changes. With formatingbrush I tried but no result too. Thanks Iraj. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a conditional formating rows with text and values
You could select Range("A5:M205") and set the conditional format for all of
the at the same time. That way you would not have any copying to possibly change the formats and contents of other cells in the range. "Iraj" wrote in message ... I have a list of text and values i.e A5:M5 and 200 rows beneath. I highlighted A5:M5CFNew ruleUse a formula to determine which cells to format =$A$5=10%Format color yellowok. When A5 is + 10% the A5:M5 will be automatically yellow, but when I want to copy this format to the beneath rows it will change all the original text and values. Is there any rule to copy this conditional formating to following rows that original text and values don't changes. With formatingbrush I tried but no result too. Thanks Iraj. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a conditional formating rows with text and values
But this kind of formating will change the whole sheets color by just any
cell value=10%. Where I want the specific rows which has 10% values to be color formated and not the complete sheet at once. I have done all that I thought it may help but no resul so far. Thanks Iraj. "JLGWhiz" wrote: You could select Range("A5:M205") and set the conditional format for all of the at the same time. That way you would not have any copying to possibly change the formats and contents of other cells in the range. "Iraj" wrote in message ... I have a list of text and values i.e A5:M5 and 200 rows beneath. I highlighted A5:M5CFNew ruleUse a formula to determine which cells to format =$A$5=10%Format color yellowok. When A5 is + 10% the A5:M5 will be automatically yellow, but when I want to copy this format to the beneath rows it will change all the original text and values. Is there any rule to copy this conditional formating to following rows that original text and values don't changes. With formatingbrush I tried but no result too. Thanks Iraj. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Conditional formating in a List of text and values. | Excel Worksheet Functions | |||
Copying conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating copying (Max Min) | Excel Worksheet Functions | |||
copying conditional formating | Excel Worksheet Functions | |||
list two columnar values based on conditional formating (text color) | Excel Worksheet Functions |