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
Bookmarks