Select your range
Create the following CF : =$I2="WIP" and format accordingly
Do the same for the other values
To make sure the CF will follow when extending the range, organize your data as an Excel Table
Select your range
Create the following CF : =$I2="WIP" and format accordingly
Do the same for the other values
To make sure the CF will follow when extending the range, organize your data as an Excel Table