• 461K Members
• 5,753 Online
• 559K Conversations
SOLVED

New Contributor

# Copy conditional formatting for several rows

Hi, I have 20+ cells/columns per row with different values and I've added one column giving the average value per row.
Thereafter I've used conditional formatting giving the individual cells red or green colour if it is  below or above the average number per row. It is easy to arrange this row by row, but having hundreds of rows I want to copy the formula for the conditional formating with colours to all rows.
E.g. B2 to X2 gives an average of 130 which I show in cell Y. If C2, D2, E2... is above 130 = green. Below 130 = red. etc

Now, B3 to X3 gives an average of e.g. 95... B4 to X4, average e.g. 45...and so on.

When just copying the formatting for row no 2, it relates to the average on row 2.

I want this to relate per row 2, 3, 4...etc with their individual average number per row, without doing this manually row by row, but copying the rule to be valid for all my hundreds of rows, but relating to the individual row-average.

If it was just one number to relate to, it's of course easy, but I need it to follow row by row.
Anyone?

3 Replies
Solution

# Re: Copy conditional formatting for several rows

You may apply a rule with the formula like

=B2>\$Y2

to entire range, let say \$B\$2:\$X\$1000

One rule per color

# Re: Copy conditional formatting for several rows

@Sergei Baklan Great, thanks Sergei!

# Re: Copy conditional formatting for several rows

@Anders190210 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies