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 January 16, 2023 - 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!

Conditional formatting multiple rows in Excel
Excel date format dd.mm.yyyy - Guide
Excel formula to change cell color without conditional formatting - Excel Forum
Position formula in excel ✓ - Office Software Forum
Screenshot in excel - Guide
Allow multiple downloads chrome - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Excel - IF function with multiple words

Highlight cell if another cell contains any text

Conditional format based on another cell containing text

Similar discussions

Subscribe To Our Newsletter!