Highlight row on drop down selection

Originally Posted by NBVC

Maybe you can attach a copy of your spreadsheet and I will try to apply the format for you.

Note: I have assumed your dropdown list is a result of Data Validation. If it is a combobox instead, then you will need to assign the cell beneath the combobox... and then the Conditional formatting will be =$A$1=3 where 3 represents the third entry in your list which would correspond to "high"

Thank you very much, hopefully you should find attached a template of the spreadsheet.

Note: Drop down source is in Sheet2
The Column headed ‘Priority’ (H), contains the drop down. When ‘High’ is selected from the list I would like that row to highlight red.

Originally Posted by NBVC

Wouln't you know it? The word "High" in cell A1 of Sheet2 contains an extraneous space at the end. Please delete that space and then go back to sheet 1 and reselect "High" in the drop downs of column H.

LOL!! Typical, many thanks, as you rightly suggest, removing the space fixes it!