Solved How to fill color in the cell having negative value

September 5, 2017 at 10:15:23
Specs: Windows 10
Hello, I'm stuck in this point. I wanted to get the date difference between two cells. I had written this formula for getting the date difference between two cells eg: "=IF(C16>D16,"-"&DATEDIF(D16,C16,"d"),(DATEDIF(C16,D16,"d")))" Now here i'm getting the negative value, now here what i need is that if the value is in negative value then the cell should automatically turn into Red colour. which i'm not able to figure out how to do it. so please if any one can help me out on this would be greatly appreciated.

See More: How to fill color in the cell having negative value

Reply ↓  Report •

#1
September 5, 2017 at 11:58:05
✔ Best Answer
Conditional Formatting makes this really easy. Just choose the "Less Than" option and set the value to 0.

A Google search on Excel Conditional Formatting will return more sites with tips than you'll know what to do with. ;-)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question