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
- You are a star Hans..... thank you for your help
Ah, OK.
You had a ton of conditional formatting rules; I tidied them. I hope it works the way you want now.
- Thank you as always Hans.
I am not sure what you mean about conditional formatting in NW. It might be the way I explained it, How it looks in NW is how I want each code to look on the actual chart, Does that make more sense?
Nicola See the attached version for the modified formulas.
I don't understand why you want to use conditional formatting in column NW.
Found it - if you need a password please use Merlin123
Don't you see an area with the text "Drag and drop here or browse files to attach"?
If not, you can upload the workbook to for example Dropbox, OneDrive or Google Drive and post a link to the uploaded and shared file here.