conditional format

  • Thread starter Thread starter skc
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

conditional format question 3
Excel conditional formatting with Weeknum 4
Park and Ride in to Central London? 2
Conditional Formating =mod($a2,2) = not(mod($a2,2)) 3
Excel VBA 1
Access Parking violations Access Database 0
I want to highlight a column if the date in cell #4 is this week. 4
Sumif based on 2 conditions 1

Back
Top