Hi friends,

The peace of code is working fine with correct output but I want to add one more condition to it to get more perfect output if the column C has a value (marks) then only the code should work.

For Each cell In Worksheets("Semester1").Range("B10:B90").Cells
    If cell.Value = "" Then
          cell.EntireRow.Range("C1:G1, K1:O1").Value = "L"
          'cell.EntireRow.Range("C1:G1, K1:O1").Font.ColorIndex = 3
      cell.EntireRow.Hidden = True
    End If
  Next cell
In short the conditions are:
If column B is blank and column C has a value of marks then only I want a “L” remark in given range.

Please suggest me a code for it.

Any help will be appreciated.

Thanking you,