conditional format

S

skc

i have used two of the functions but ii need to have a color to hightlight
all cells that have parking, p, prk
 
S

Sheeloo

Do you want to higlight cells having these values or containing these in
their values?

To highlight Cell A1 (in the latter case)
Choose Conditional Formatting
Use FORMULA IS
=OR(A1="parking',A1="prk",A1="p")
and format as you want

In the former case you really need to have value CONTAINING p
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
How can the font and size of (all) citation numbers be altered? 1
Changing row background from external program 0
Address Format changed after Migration 0
Tracked changes by multiple people modified to one 0
Conditional formatting dates 3
Match table shading (color) to Visio color/Transparency 1
Need help modifying code 0

Top