Forum Discussion
Help with formulas
I copied the formulas from my previous attachment and adjusted them for the slight differences in layout (codes in column NW instead of NX, and H1/H2 in row 13/14 instead of 16/17).
Hi Hans
You kindly helped me before with my Excel leave tracker and I now have another query.
I have added a CF code (carried forward) which is when a staff member is using up leave from the previous year, so I do not want it to add to the totals for the current year but I cannot figure out how to stop it, are you able to help.
Also, I would like the codes in column NW to come out to show with same formatting in the sheet, but they do not unless I manually change them. How do I adjust this (for example if you type in H1, M P, C it is not Bold or CF doesnt show colour)
I would appreciate your help if you have a moment. I cannot see anywhere to attach the document again.
Kind regards
Nicola