Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formatting
I used conditional formatting property for one row such that if $M$2="X" then
apply formatting to $A$2:$O$2. That formatting rule works. Now I want to apply that formatting to all rows such that if $M$3="X" then apply the same formatting to =$A$3:$O$3 and if $M$4="X" then apply the same formatting to =$A$4:$O$4 and so on. How can I copy the formatting to all sheet as I explained above. Regards, Ozgur... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formatting
Get rid of absolute reference on row number, e.g.:
Formula is: =$M3="X" Apply this to row A3:O3, then you can copy down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ozgur Bilgin" wrote: I used conditional formatting property for one row such that if $M$2="X" then apply formatting to $A$2:$O$2. That formatting rule works. Now I want to apply that formatting to all rows such that if $M$3="X" then apply the same formatting to =$A$3:$O$3 and if $M$4="X" then apply the same formatting to =$A$4:$O$4 and so on. How can I copy the formatting to all sheet as I explained above. Regards, Ozgur... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Conditional Formatting? | Excel Discussion (Misc queries) | |||
Can I copy conditional formatting? | New Users to Excel | |||
copy conditional formatting | Excel Discussion (Misc queries) | |||
... Can I Copy Conditional Formatting... | Excel Discussion (Misc queries) | |||
copy conditional formatting | New Users to Excel |