Changing color of a row in Excel [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I'm trying to create an Excel spreadsheet that if a cell is greater than 4, the whole row changes color to red automatically (without setting macro to a button).

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
use conditional formatting. Since you want to apply to whole row, make sure that you select the whole row before you apply the conditional format.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!