Hi Experts,
In my whole work sheet I want to highlight any cell which is like that: any cell will be highlight if its next down cell contains same character. Example 1: A1=Pen, A2=Pen, A3=Pen, now A1 needs to highlight automatically & font will be bold also. Example 2: B1=Pen, B2=Paper, B3=Paper, B4=Pencil, B5=Pencil, B6=Paper. Now in this example I want to highlight automatically B2 & B4 as per condition. Hints: Next Down cell means next row cell & if next row cell is blank then condition will count next 2 row, as like if C1=Pen, C2=(Blank), C3=Pen then A1 will be highlight with Bold font. This condition can explain another way: if previous row cell character not match with next row cell then next row cell should highlight with bold font. Example 1: D1=Computer & D2=Laptop then Both will be highlight because both previous row cell value not match with next row cell value. Please help me.
Regards
rachelwahid
Bookmarks