Hi ,
I have a question on how to apply conditional formatting of one row to other rows without using format painter ? The issue is that a have over 100k rows.
To be more specific i attached a sample .
Hi ,
I have a question on how to apply conditional formatting of one row to other rows without using format painter ? The issue is that a have over 100k rows.
To be more specific i attached a sample .
First find the last used cell with F5
Then Conditional Formatting - Manage rules - replace the end reference in the range in the " applies to" box with the last used you found
Go to conditional formating>manage rule>applies to>>
and then change the range, i mean select all the data from the worksheet on which you want to apply the rule.
if i select all data range , then the conditional formatting applies to all data.It`s not what i want.I need conditional formatting for one row , such as the sample attach , where for "Avec MM Impex SRL" the data is compared using the range c2:e2, i want the same formatting for "PRIMERO BUSINESS CONSULTING" range C3:E3.I can use format painter but i have 100k rows.I`m asking for another easy option.
Sorry if i`m not to good to explain what i need.
Can you help me with a solution in this matter ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks