I use the rules in the conditional formatting tab and choose that if text in cell is 'completed' change to x color and it works fine. But I need the whole row to change color based on input in one cell doesn't seem to help if a highlight row while setting up rule either..
Bookmarks