Conditional formatting multiple rows in Excel

[Closed]
Report
Posts
1
Registration date
Friday November 29, 2013
Status
Member
Last seen
November 29, 2013
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
Hello Community,
I need to create conditional formatting in Excel separately for a number of rows (e.g. high lighting highest and lowest values in each row). I have created the rules for one row and now need to apply that to all other rows. I cannot do one 'paste special' per row since I have many rows. Is there any way to do that?!
Thanks!

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
482
Hi Abateni,

I always drag my formatted cells down, messing up your data, but when done a small square appears. Clicking this square gives you the option to apply format only, thus restoring your data but keeping the conditional format.

Best regards,
Trowa