Can as at work, but it's pretty simple:

I have a row of information, with one cell in the row with a specific condition. When this condition is triggered i.e goes from blank to Y then I want that row to change colour.

I've a feeling I'm going to have to use VB