Conditional Formatting a row from a validation list

Closed
Todd - 18 Dec 2014 à 07:23
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 19 Dec 2014 à 09:50
Hello,

OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Based on the selection in the list the data on the row turns a different color. So if I was to choose YES from the list the row would be displayed in bold and if I chose NO the row would be red...I too need to copy the row down when a new entry needs to be added and tracked until closed.

So when I close out the entry on each row a color details the status of the entry.

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
19 Dec 2014 à 09:50
Todd, Godd afternoon.

Take a look at an example I did for you:
http://speedy.sh/SxBpU/19-12-2014-en-Kioskea-Conditional-Format-with-Validation-OK.xlsx

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão