Changing row color in a conditional formatting

shaftdx

New Member
Joined
Aug 20, 2018
Messages
8
ok so I pretty much just discovered conditional formatting and loving it! however I can only get the one cell to change color, I want to get the whole row to change. So I have one cell that if it has a negative number only that cell changes to red but I want that entire row to become read so it visually stands out more.

I think i have to create a table? but I don't know how to do that either.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,721
Office Version
365
Platform
Windows
If you select all the data & use a formula like
=$O2<0
it will highlight the row.
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,689
Office Version
365
Platform
Windows
No need to create a table, per se...
Just select the whole range where you want the conditional format to apply (whilst you CAN get the whole row to change colour, I'm guessing that you actually only want a certain number of columns in each row to be highlighted).
I just chose A8:C20, for example.
Then go to "Conditional Formatting" / "New Rule" / "Use a Formula" / In the box "Format values where this formula is true" box type (or paste) =$A8<0.
Then go to "Format" and set your colour etc, as you have been doing already, then "OK" everything.

Replace "A8" in my example, with the reference of the topmost cell in your data whose column you want to check for negatives.

That should be it!
 

shaftdx

New Member
Joined
Aug 20, 2018
Messages
8
ok that worked! thank you guys that is exactly what I wanted! I had to tweek something but it worked out! Thank you do much!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,721
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,102,476
Messages
5,487,104
Members
407,578
Latest member
jana007

This Week's Hot Topics

Top