Can anyone tell me how to format a cell based on the value of two cells (Excel 2007)?
Essentially, I have a spreadsheet that tracks continuous learning points on a two-year basis. I'm trying to find a formula that will format cells (color) if they do not have a minimum number of points within 60 days of the date required.
In other words: One cell contains their cumultive points earned (80 required) and the other contains their required completion date. I've tried multiple conditional formatting formulas but can't seem to write/find a combination that works. Then again, I consider myself a novice to Excel.
Any help, suggestions, or solutions are greatly appreciated.
Thank you much!!!
Bookmarks