Formatting row color based on cell status

[SDAVIDSON2024]

I work as an automotive technician. I have no experience coding or anything. I keep track of my repair orders and paid time in calc and I’m trying to have the rows change color based on what the status of the job is. Which is either- hold for parts, completed, paid, not paid. And I want the whole row where that status is at to change to a specified color. The status is always located in column D. The colors I want to use are as follows.
completed-808080
hold for parts-FF0000
not paid-b4c7dc
paid-81d41a
Is there any way to do this? thank you

[Steph1]

The solution is called Conditional formatting.
Select the rows that contain or will contain jobs. Let’s assume that the first row is row 2.
Click on the menu Format > Conditional > Condition.
In the new window, select Formula is, enter D$2="Completed" (the 2 corresponds to the first row containing job information).
Select “New style” and choose the color you want, then give it a name.
Repeat for each job statuses.

[EarnestAl]

There are two parts to this; Conditional formatting which provides the colours, and Validity that ensures that the exact words are used so the conditional formatting works.

Conditional Formatting

1. Select the cells to be used in the first row of data
2. Click Format > Conditional > Condition and at the bottom alter the Range to include your expected number of rows you will need, e.g. change A2:G2 to A2:G10000
3. In the Conditions pane change the drop down from “Cell value” to Formula is. Enter formula `$D2=“completed”
4. In the Apply Style, click the drop down and select New style…. In the new dialogue the Organiser tab will be opened, type a name for the completed style, e.g. completed. Select the Background tab, click the colour button and enter your new colour number in the Hex field. OK
5. Click the Add button to add another condition. Repeat steps 3-4
6. Repeat step 5 for the other two conditions then OK out

Validity
A misspelling will mean the conditional formatting won’t work so we need to choose from a list.

1. Click in cell D2, assuming that is the first data row. In the Name box to the left of the formula bar where it says D2, alter that to read to the end of your range, e.g. D2:D10000 and then press Enter to select.
2. Click Data > Validity. In the Allow field change from “All values” to List. Leave Allow empty cells box ticked.
3. In the Entries box type your Status entries
   completed
   hold for parts
   not paid
   paid
4. Click OK

ConditionalFormatting&Validity.ods (19.5 KB)

[SDAVIDSON2024]

I did what you laid out in the comment. However, it only works in the first line. As soon as I’m farther down it wont automatically fill the line color. will I have to do this for the whole document?

[EarnestAl]

See step 2 under conditional formatting or step one under formatting