In the 'FLOW TABLE' I need to color cells in to 3 different colors depending on the values of the "Operating issues" colomn, using Conditional Formatting.
For example,
If G cell is empty, then to color the relative cell in the 'FLOW TABLE' to the green.
If G cell contains "HiCPL", then to color relative cell in the 'FLOW TABLE' to the red.
In the attached file I showed two examples (green and red cells) in the 'FLOW TABLE' to make my question more clear. I need to cover cells with color only in the FLOW TABLE.
Please someboby help me
Bookmarks