Conditional Formatting a row from a validation list

Closed
Todd - Dec 18, 2014 at 07:23 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 19, 2014 at 09:50 AM
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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 19, 2014 at 09:50 AM
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
0