Formatting Cells

S

Scott

I would like to search a column for cells containg certain text and then
formatting those cells a different color. How do I go about doing this?

Thanks for your help!!
 
P

Paul Sheppard

Scott said:
I would like to search a column for cells containg certain text an
then
formatting those cells a different color. How do I go about doin
this?

Thanks for your help!!
Click to expand...

Hi Scott

Use Conditional Formatting

Select the range of cells containing your data, then Format
Conditional Formatting, in the boxes for Condition 1, leave the firs
as Cell Value is, chnage the second box to equal to, in the third bo
enter the text you want to find, then click the format button an
choose the formats you want and click O
 
C

CLR

The feature you're looking for is called "Conditional Formatting"......do
Format > Conditional Formatting and follow the menus......check "Help" and/or
post back if you have problems or specific questions about it.....

Vaya con Dios,
Chuck, CABGx3
 
S

Scott

Thanks that worked. Is there a way to look for partial text within a range
of cells and have the format changed if it contains that text or does it
always have to be an exact match?

Thanks again!
 
Top