Hi again
In Columns I, L and O I have various drop down options (4 in total)
If these dropdowns are any combination of either "Approved" or "Not Applicable" I need to turn the row green
If the row contains one of the other values "Open" or "Escalated" (or blank) the line should remain free of being coloured in
Thanks
In Columns I, L and O I have various drop down options (4 in total)
If these dropdowns are any combination of either "Approved" or "Not Applicable" I need to turn the row green
If the row contains one of the other values "Open" or "Escalated" (or blank) the line should remain free of being coloured in
Thanks