highlight horizontal row - please help

You'll need a macro to do this.

I've added a macro to Sheet1 object within the VBA. I've also added 3 new named ranges, and a conditional formatting formula.

perfect! exactly what I was after, and so fast I can't believe how quickly you resolved it.

THANK YOU EVER SO MUCH!

to incorporate this into my actual workbook sheet do I just copy and paste the vba code and create the same conditional formatting? is there any other part to it?

Yes, I would do the following in this order:

1) Create the 3 new named ranges
2) Apply the conditional formatting
3) Copy the VBA code over.

right that explains it, "named ranges" know nothing about that, where is it, how do i copy it?

Whoa, isn't it like, 4.45am up in London?

They are at.. Formulas tab --> Name Manager (or Alt --> M --> N) but the easiest way to copy across is to do the following.

In the file I uploaded, choose 3 random blank cells, say... Q1, Q2 and Q3

Q1: =SelectedRow
Q2: =SelectedColumn
Q3: =ColumnWithinRange

Then copy Q1:Q3, and paste it over at your other workbook. That should import the 3 named ranges over.

done it! works perfectly!
yes its 4.54 am now - and I know I'm mad staying up all night for this, day at home tomorrow sleep the whole day. ALL BECAUSE I WANT TO GET THE COLOURS RIGHT!!! MAD

Haha, the things we do for Excel.

Hope you have a good sleep. Please close this thread if it is all resolved.

Thread Tools above your first post, "Mark your thread as Solved"

OK thanks will do

good afternoon to you there