How can I conditional format for the whole row? In a list if column C shows
"new" for a new client, how can I ensure that the whole row is automatically
turned blue with white writing(for example)?