![]() |
#2
|
||||
|
||||
![]()
I would not advise using CF on an entire sheets, as it will slow your sheet down tremendously
Does your word always appear in the same column ( different rows)? If so, select a number of rows starting in row1 ( again, not too many and not necessarily all columns) at once then use the following assuming your words appear in col C =ISNUMBER(SEARCH("withdrawn",$C1)) and format as required If in different columns try =SUMPRODUCT(--NOT(ISERROR(SEARCH("withdrawn",$A1:$Z1))))>0 as CF (there should be something more elegant)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | SarahH7 | Excel | 5 | 06-27-2018 11:43 AM |
![]() |
solberg2004 | Excel | 2 | 01-27-2017 10:07 AM |
![]() |
dayperson | Excel | 1 | 02-23-2016 09:07 AM |
![]() |
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |