• IMPORTANT NOTICE: The Excelguru Help Forums will be permanently shut down on Friday, June 26, 2026.

    With AI taking a more prevalent role in answering user questions, the traffic to the Excelguru Help Forums has seen a sharp decrease in traffic over the past couple of years. We do not see this trend changing anytime in the near future. As such, continuing to run the forums is just no longer feasible, so we have made the difficult decision to close them down at the end of the month.

    We appreciate everyone who joined our forums to ask and answer questions over the past decade – and in particular – want to say a huge THANK YOU to the moderators and administrators who volunteered their time and expertise on a daily basis. You made the community what it was.

    NOTE: NEW USER ACCOUNTS CAN NO LONGER BE CREATED.

Row highlight Macro

M

MrBxx

New member
Joined
Aug 27, 2023
Messages
2
Reaction score
0
Points
1
Excel Version(s)
2010
Hi folks, I’ve been using conditional formatting to highlight a cell when it contains a certain text. what I would like to do is highlight the whole row….so,

I import data from one sheet and it sits in range B5:K46. Is there a macro code I could use to automate that:

If any text in Row I has “RT” in it, it will highlight the whole row from B5 to K5 in dark blue with white font and not just I5. it will then do this for any other row where “RT” is in the cell it highlights that row also.

I’ve searched the site but can’t find a macro code that could work.

Thanks Paul
 
crossposted

A Message to Forum Cross Posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →
excelguru.ca excelguru.ca
 
You must log in or register to reply here.
Back
Top