Hi,
I have been staring at my spreadsheets all day and now my brain is refusing to work.
I am trying to get a formula that will highlight rows where cell K contains a specific word.
For example - highlight row if cell K contains the word complete.
It only needs to search for the text in K but needs to highlight all the rows that contains "complete" in that column".
Does that make sense?
Thanks in advance for any help.</SPAN>
I have been staring at my spreadsheets all day and now my brain is refusing to work.
I am trying to get a formula that will highlight rows where cell K contains a specific word.
For example - highlight row if cell K contains the word complete.
It only needs to search for the text in K but needs to highlight all the rows that contains "complete" in that column".
Does that make sense?
Thanks in advance for any help.</SPAN>