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.
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
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |