Hi,

I have a condition format that highlights a whole row if the text in a field is "Refresh". I use the formula below and it works well.

=INDIRECT("E"&ROW())="refresh"

The new issue i have is that i need to add numbers to the word refresh so it will now look like Refresh-1, Refresh-2,Refresh-3,Refresh-4 and so on...

how do i use the same formula to highlight the row if the cell "contains" the word refresh?

Thanks

Viren