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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,803
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,691
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,803
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,102,597
Messages
5,487,765
Members
407,610
Latest member
bellakim00

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top