Get instant live expert help on I need help with vba highlight cell

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

To update existing Excel VBA to include to select any highlighted cells in several columns, recalculate the corresponding cell in another column, highlight that cell and move that column and the corresponding cell with the highlight over to the audit history columns.
Solved by G. C. in 19 mins
We have a lottery bingo sheet where each entrant picks 6 numbers and when they come out in the lottery they get highlighted in grey. At the moment I am having to go through each individual line/cell to highlight manually. I would like to create a formula/macro/vba to automatically highlight a cell if the value in it is in the range of data where I put the lottery numbers. I have had it done for me in the past but it was by a customer who no longer comes in to the pub, but 'm sure he used a macro/vba. Cheers
Solved by D. D. in 16 mins
I need formula to highlight cell value from range in cell
Solved by M. H. in 18 mins
VBA code to select slicer selection via single cell
Solved by I. J. in 28 mins
Hi there, I've got multiple lines of text that I would like conditional formatting added to, to highlight each sentence differently as it appears in a cell. i.e. Peter Rabbit (cell: a1 - highlight: red) Mother Goose (cell: a2 - highlight green) Simon Peter (cell: a3 - highlight: yellow) and so on... but the toolbar option only seems to allow for one colour and one parameter. Is there an equation for it? Thanks
Solved by I. J. in 13 mins