I cannot get conditional formatting in Excel 2010 to work on this formula.
I have this formula entered to calculate the number of days that have passed since the last event. What I need is conditional formatting to highlight the cell where this formula is if the result of the formula is >29. So anything event that is 30 days past or more should be formatted.
When I try the conditional formatting in Excel every cell is highlighted even if the result of the formula above is less than 30. I know there is something screwy about conditional formatting and formulas but I cannot remember and I have not been able to get this to work.