ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB Code to Conditional Format a Cell Range (https://www.excelbanter.com/excel-programming/345068-vbulletin-code-conditional-format-cell-range.html)

VCSGroup

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