Hi Excel Geniuses
I've attempted to create formulas here that reference texts in column H to fill the entire row
i.e.
1. "Open" returns no fill for the entire row
2. "Complete" or "Complete *more text*" returns blue fill for the entire row
3. "In Progress" or "Awaiting *more text*" or "Review *more text*" or "Report *more text*" or "Ongoing" returns green fill for the entire row
Each time I think I've succeeded, something goes wrong i.e. "Complete" in column H returns green fill for entire row instead of blue.
Where am I going wrong?
Thank you,
Mayhem
I've attempted to create formulas here that reference texts in column H to fill the entire row
i.e.
1. "Open" returns no fill for the entire row
2. "Complete" or "Complete *more text*" returns blue fill for the entire row
3. "In Progress" or "Awaiting *more text*" or "Review *more text*" or "Report *more text*" or "Ongoing" returns green fill for the entire row
Each time I think I've succeeded, something goes wrong i.e. "Complete" in column H returns green fill for entire row instead of blue.
Where am I going wrong?
Thank you,
Mayhem