Hi everyone,

I have a simple query which i'm sure is simple for all of you excel genius's but i'm struggling to make it work.

My question is as follows:
If i was to put "No Survey Required" in Cell A1, I want a selection of other cells to all format to the same colour (Grey)

Basically, I have several columns. column A1 = Survey Date. If no survey is required, I want all the cells in that row relating to the survey to be grey'd out.
For the purposes of this question, Lets say, A1 = Survey Date (Populated with "No Survey Required") and I want A1, B1, C1, D1 & E1 to be greyed out.

Im stuck. Hope you can help