Validity in calc

[tezza]

I have a spreadsheet for travelling times start job finish job, and time travelled. Included is a cell showing, JOB Number, but this also could show training, sick, holiday, complete. What I’m trying to achieve is using the Validity function, but having each input in the validity list having a different colour, so when the input has been action the background shows the input, giving a visual indication, as shown below, this what I would like to see in appropriate cell. At the moment if I have list see below and activated the validity down arrow the entry always has a white background, not a coloured background!
Have copied and pasted above from writer, but list does not show background colours

holiday
sick
training
Job number
complete

[Steph1]

If you would like to set up the background color of a cell (or a row) depending on the content of the JOB cell, you should look at conditional formatting (PDF document).

[Villeroy]

ask121533.ods (69.0 KB)

[EarnestAl]

Wouldn’t you want job number and complete? Or job number and training if the training is required for a particular job?
I would be inclined to separate out job number to another column.
Maybe also the job status, complete, estimate, etc