ExcelBanter - conditional format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional format (https://www.excelbanter.com/excel-worksheet-functions/222469-conditional-format.html)

skc

conditional format

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

Sheeloo[_3_]

conditional format

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

"skc" wrote:

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

All times are GMT +1. The time now is 12:07 PM.