Hello all
I need to be able apply a conditional format to values in a row based on a specific value. Each row and associated format will be based on a different value. In the attached example the data C:G needs to be highlighted if equal to the value in H for each associated row.
I have tried this myself, but made a huge mess of it. Can anyone help with some example code?
thanks
Nick
example.xls
Bookmarks