We have a status line in excel and the boss is spending a lot of time formatting and reformatting.
status is a columb, lets call it "H"
If the status = good, format whole row green
If the status = working, format whole row yellow
If the status = blank, format whole row white.