Conditional Formatting on row based on a cell value

Question

I'm generating an Excel document from a template and I'm trying to apply a color to a row based on the value of data entered. So my data contains a Status property, that is either Open or Closed.

How do I set the row to Green if cell value is Open and Red if cell value is Closed?

Thanks

Ramya Sivakumar · Accepted Answer

Hi Brian,Greetings from
Syncfusion.We have prepared
the sample to set the row
to Green if the cell value is Open and Red if the cell value is Closed. kindly try this and let us know if the
solution helps.Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/F-17486046736822Regards,Ramya.

Brian · Answer

Thanks. This is exactly what I needed

Ramya Sivakumar · Answer

Hi Brian,We are glad that
the provided suggestion helped you. Kindly let us know if you need any further
assistance.Regards,Ramya.