Colour coded Validation Lists?

Originally Posted by darklord

Hey Guys,

Another quick query, I was wondering is it possible to get the sheet to change the whole row red when failed is selected? (or green when pass etc)

The single cell works fine through Conditional Formatting, I can't see an obvious way to change the whole row though.

Cheers,

Daniel.

Hi
if you enter "pass" or "fail" in coloum B then in Conditional Format window use this formula:
Formula is: =$B1="pass" and choose green colour
add>>
Formula is: =$B1="fail" and choose red colour

added comments.........
you should first select the whole sheet then apply conditional formatting as mentioned above.
...............................

see attached file as well.

Originally Posted by darklord

Wow that's great thanks for that! The example sheet really helped to.

I've got my sheet all up and running now. :-)

Daniel.

you're welcome here. good to see that your problem is solved.