Hi, I've been developing this attached spreadsheet with the help of a few experts here. I've expanded upon it and am running into a couple of simple but puzzling problems.
Q1. How come Cell A1 and A2 are not computing??
I must have entered a "mode" in Excel but don't know what it is. The cells literally display the above formulas instead of computing the values.
Q2. in Column P and Q I have conditional formatting. How come only column P is highlighted? P and Q should both be highlighted as the range applies to both columns.
Thanks and best regards, Lyteck