Change text color in cells IF text in ANOTHER cell equals 'Goods In' etc

[LukeAcrelands]

I have a table with 6 columns. The first column is a drop-down list with 5 options indicating whether a row is Stock IN or Stock OUT. I need the rest of the corresponding row to change text color depending on the value in the drop-down list. For example:-

IF Cell A1 is equal to "Own Haulier In" make the text in the row RED
IF Cell A1 is equal to "Own Haulier Out" make the text in the row BLACK
IF Cell A1 is equal to "Collection Out" make the text in the row PURPLE
IF Cell A1 is equal to "Delivery In" make the text in the row GREEN
IF Cell A1 is equal to "Delivery Out" make the text in the row BLUE

I understand that it needs to be conditional formatting, most likely with a nested IF statement but I am struggling. HELP PLEASE!

Thanks in Advance.

 

[Joe4]

Welcome to the Board!

Not a nested IF, but rather separate Conditional Formatting rules, one for each color.

So, you would select the entire rows, and then use this Conditional Formatting formula for the first one:
=$A1="Own Haulier In"
and choose the red color.
Repeat for the other rules.

 

[LukeAcrelands]

Fantastic, thank you!

 

[Joe4]

You are welcome.

If you want to exclude column from the coloring, just select the ranges you want it applied to (i.e. columns B-F, starting in row 1 down as far as you want).