View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Betsy Betsy is offline
external usenet poster
 
Posts: 32
Default 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?