#1
|
|||
|
|||
Conditional Formatting
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 |
#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)
__________________
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 |
#3
|
|||
|
|||
Conditional Formatting
Hi Pecoflyer
Apologies for the delay. This worked perfectly for me. Many thanks, Joanne |
#4
|
||||
|
||||
You're welcome.
Please mark thread as solved ( see my sig)
__________________
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 |
#5
|
|||
|
|||
Marking as solved?
Hi
Apologies if it is obvious, but I can't see how to mark a problem as solved. |
#6
|
||||
|
||||
It is explained in my signature
__________________
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 |
#7
|
|||
|
|||
Marking as solved?
Still not getting it. When I click on "Thread Tools", I just get "Printable Version" option.
|
#8
|
|||
|
|||
Apologies, please ignore the last message!
|
#9
|
||||
|
||||
No worries
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | SarahH7 | Excel | 5 | 06-27-2018 11:43 AM |
Conditional Formatting | solberg2004 | Excel | 2 | 01-27-2017 10:07 AM |
Conditional formatting | dayperson | Excel | 1 | 02-23-2016 09:07 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |