Hi

I have used conditional formatting to highlight a particular cell but is it possible to format a spreadsheet so that if a particular word (in this case "withdrawn") is entered into a cell, the whole row is highlighted, not just that cell?

Many thanks,
Jo