ExcelBanter - Highlight Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Highlight Cell (https://www.excelbanter.com/excel-programming/423505-re-highlight-cell.html)

RadarEye

Highlight Cell

Hi Billy,

A cell can not have a color.
You can use Cells(Row,1).Interior.ColorIndex = 4 to color the
background
Or use Cells(Row,1).Font.ColorIndex = 4 to color the value

HTH,

Wouter

Billy[_7_]

Highlight Cell

Thanks

All times are GMT +1. The time now is 02:00 AM.