VBA – change cell formatting based on another cell’s format
How to change cell formatting based on another cell’s format?
highlight cell if other cell range have highlight
highlight or add comment box on header cell if below cell range have highlight color I had tried with If ActiveCell.Interior.Color = 255 Then Range(“A8”).SelectSelection.Interior.Color = 255 but not working. and also add comment box.