![]() |
VB Code to Conditional Format a Cell Range
I have a spreadsheet that has text information entered from rows 1 to 10
and in clumns A to F. What is the code to look in column A, rows 1-10 for a text value, if found, shade the entire row from column A to F(Not just the cell). These cells will be reused on regular basis so I also need to have the code to remove the shading if text is blank and if text is not found. |
All times are GMT +1. The time now is 06:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com