I have written this vb.Net code i have added namespaces as well but facing the issue of
Unexpected error has occurred during the library compilation process:
The assembly compilation returned the following errors:
The type or namespace name ‘Application’ does not exist in the namespace ‘Microsoft.Office.Interop.Excel’ (are you missing an assembly reference?)
you can easily use the UiPath activities like this example
in your if activity validate that the cell is empty, if so, then lookup the value to retrieve the cell value and the pass that value to the set range color
String.IsNullOrEmpty(CurrentRow("yourColumnName").ToString) Or String.IsNullOrWhiteSpace(CurrentRow("yourColumnName").ToString)