Previous Topic Next Topic

Conditional formatting multiple rows in Excel

Closed
abateni Posts 1 Registration date Friday November 29, 2013 Status Member Last seen November 29, 2013 - Nov 29, 2013 at 04:47 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 5, 2013 at 10:24 AM
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!
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 5, 2013 at 10:24 AM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses