Hi. I’m trying to Set Range Color in Excel using an If statement to provide conditions. I want the Set Range Color to cover the entire scope of the Sheet and color which ever conditions apply. How do I make my selector dynamic? I have set a variable(RangeIndex) for my for each row output. That is the one pictured. Please let me know How I could do this… Yes, there are headers in the datatable.