I am working on a build sheet where we will be doing checks manually now.
I need your help to automate the 3 tasks.
1. Spell check
2. Highlight rows which dont have any plots. (In the attached row 4 has no plots)
3. Highlight columns which have unique plots.(in the attached column F and H has unique plots)
For spell check , i find the below macro online from excel tricks. but i need your help on adding the task2 and 3 with this macro.
For Each cl In ActiveSheet.UsedRange
If Not Application.CheckSpelling(Word:=cl.Text) Then _
cl.Interior.ColorIndex = 28
The attached is only sample and the column/row may be varied.