I have a table where if the text in a cell in the first column is "not eligible" then I would like every cell in rest of that row to be automatically populated with "not eligible" and greyed out. The other cells in the row contain formulas to calculate values based on the value in the first column. I want to use conditional formatting because this Excel worksheet will be used as a template and passed around so keeping the formulas in the other cells intact is important.

I can use conditional formatting to turn the text grey in the row based on the contents of the first column.

I can also use this formula =IF(ISNUMBER(SEARCH("not eligible",$G12)), "not eligible", "") to generate the "not eligible" text based on the contents of the first cell but I can't seem to get it to work in conditional formatting.

Is it possible to do this?