LukeAcrelands
New Member
- Joined
- May 17, 2018
- Messages
- 2
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.
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.