Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I have a huge spreadsheet. I need to search for every cell that contains the
word "call" or "meeting" and highlight that cell. How do I do this using conditional formatting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Select the entire sheet (A1 active), then apply CF using Formula Is:
=OR(A1="call",A1="meeting") Format to taste, ok out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Betsy" wrote: I have a huge spreadsheet. I need to search for every cell that contains the word "call" or "meeting" and highlight that cell. How do I do this using conditional formatting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thanks. I must be doing something wrong. I selected the whole worksheet
((A1 active) then selected "formula is" from the dropdown, then thped =or(A1="call,A1="meeting") I then selected format and used the Patterns tab and selected a shade. Nothing happened "Max" wrote: Select the entire sheet (A1 active), then apply CF using Formula Is: =OR(A1="call",A1="meeting") Format to taste, ok out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Betsy" wrote: I have a huge spreadsheet. I need to search for every cell that contains the word "call" or "meeting" and highlight that cell. How do I do this using conditional formatting? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
=or(A1="call,A1="meeting")
you had a typo in the above, it should be "call" But if it still doesn't work despite the correction, then try this more robust: =OR(TRIM(A1)="call",TRIM(A1)="meeting") (there could be leading or trailing white spaces for the 2 words keyed into cells which are not readily apparent. TRIM will take care of these.) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Betsy" wrote: Thanks. I must be doing something wrong. I selected the whole worksheet ((A1 active) then selected "formula is" from the dropdown, then thped =or(A1="call,A1="meeting") I then selected format and used the Patterns tab and selected a shade. Nothing happened |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
If the 2 words: call, meeting could be part of a text string within the same
cell, use this rendition instead: =OR(ISNUMBER(SEARCH("call",A1)),ISNUMBER(SEARCH("m eeting",A1))) Replace SEARCH with FIND if you need it to be stricter, case-sensitive. SEARCH is not case sensitive. The earlier 2 suggestions assume that the cell(s) would contain only the word(s). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Yes, the words are part of a text string within the cell. I tried this and
it still didn't work! I double-checked my typing on the formula and typed it exactly like you showed below. Any other suggestions? And by the way, thanks for all your help! "Max" wrote: If the 2 words: call, meeting could be part of a text string within the same cell, use this rendition instead: =OR(ISNUMBER(SEARCH("call",A1)),ISNUMBER(SEARCH("m eeting",A1))) Replace SEARCH with FIND if you need it to be stricter, case-sensitive. SEARCH is not case sensitive. The earlier 2 suggestions assume that the cell(s) would contain only the word(s). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Here's a quick sample to illustrate that it works
(contains a screenshot of the CF dialog): http://cjoint.com/?igr0svfXIl Betsy_CF.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Betsy" wrote: Yes, the words are part of a text string within the cell. I tried this and it still didn't work! I double-checked my typing on the formula and typed it exactly like you showed below. Any other suggestions? And by the way, thanks for all your help! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
That got it! Don't know what I was doing wrong! Thanks again!!!!!!!
"Max" wrote: Here's a quick sample to illustrate that it works (contains a screenshot of the CF dialog): http://cjoint.com/?igr0svfXIl Betsy_CF.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Betsy" wrote: Yes, the words are part of a text string within the cell. I tried this and it still didn't work! I double-checked my typing on the formula and typed it exactly like you showed below. Any other suggestions? And by the way, thanks for all your help! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
glad to hear that, Betsy. you're welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- On Aug 7, 1:58 am, Betsy wrote: That got it! Don't know what I was doing wrong! Thanks again!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting/VBA | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |