Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet with columns A-K and rows 1-56. If any value in D3 through J3 goes below 0, I want the entire row (A through K ) to have a special format. I've gotten close in Excel 2010 by using the Home ->Conditional Formatting->Manage Rules->New Rule and I created a formula rule where the Formula is


and in the Applies to I have =$A$3:$K:$56

What happens now is it works great for any value in Column D ONLY. When values in E-J change I get no formatting. Anybody know why?

share|improve this question

migrated from Dec 24 '11 at 1:35

This question came from our site for professional and enthusiast programmers.

up vote 3 down vote accepted

Try this formula instead: =COUNTIF($D3:$J3,"<0")>0

share|improve this answer
Awesome! Thanks. – Tod Dec 22 '11 at 20:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .