Chart Red
Trying to have dates on an exel chart turn red if they exceed a holding time.?
I have two columns of dates. I need the date in the second column to turn red it it is >2 days different from the first date. I have been trying the conditional formatting using cell is greater than "DAYS360(A:A,B:B)=2. It is not working---any ideas?
The two columns are next to each other so it is 2/14/09 2/16/09
2/16/09 2/20/09. I tried the $A1+2 ==not working
Set up a hidden column with that formula in it. Then use conditional formatting in your data column that says "If cell value is greater than" and reference your hidden column in your conditional formatting within the original data cell.
 |
 15 QUALITY Satin Ribbon Wedding Party Favor CHART A $3.75 Time Remaining: 2d 18h 14m Buy It Now for only: $3.75 |
 15 Quality Satin Ribbon Wedding Party Favor CHART B $3.75 Time Remaining: 2d 18h 16m Buy It Now for only: $3.75 |