Previous Topic Next Topic

Conditional formatting on an entire row

Solved/Closed
AKA - Mar 1, 2016 at 10:27 AM
 AKA - Mar 4, 2016 at 09:46 AM
Hello,

I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12<0 but it only applies this formula to two cells at a time - what to do?

Related:

3 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 1, 2016 at 12:03 PM
Hi AKA,

Try this:




Best regards,
Trowa

0
AKA
Mar 2, 2016 at 11:00 AM
This didn't work I guess because what I want is based on one cell in the A column being less than 0. When A12 is less than 0 I want the rest of the cells in row 12 to turn red.
I am highlighting the whole row then putting one formula into conditional formatting. Any other thoughts?
0
Answer 2 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 3, 2016 at 11:24 AM
Hi AKA,

Thought you only wanted it for row 12.

Change the last part into the row range you want to apply the conditional formatting. Also make sure that the first part refers to the row you currently selected.

So select row 12, add new rule, formula: =12:12<0, select color, change applied range to =$1:$1048576.

Now whenever a value in column A is below, the corresponding row will turn red.

Best regards,
Trowa
0
Answer 3 / 3
AKA
Mar 4, 2016 at 09:46 AM
Thanks!
0

Similar discussions

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

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

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response