Conditional Formatting Help Needed
I have my timesheet set up so that in column B the number 1 or 2 indicates whether or not it is overtime payment. What I am trying to acheive is to add a third trigger - the number 3 which will auto write the word Röd dag (Swedish version of bank holiday) in the relevant C column. The C column is used to manually enter the Start time of my shift so I cannot insert a formula there. Can this be done through conditional formatting?
I have attached a copy of my time sheet and left some entries under the Jan page to indicate better what I am wanting to do.
Any and all help will be appreciated.