Report

Conditional formatting on an entire row [Solved]

Ask a question AKA - Last answered on Mar 4, 2016 09:46AM
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?
See more 
Helpful
+0
moins plus
Hi AKA,

Try this:




Best regards,
Trowa

AKA- Mar 2, 2016 11:00AM
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?
Reply
Add comment
Helpful
+0
moins plus
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
Add comment
Helpful
+0
moins plus
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!