Thank you, this is exactly what I needed to know. I appreciate the detail you
provided.

"Trevor Shuttleworth" wrote:

You can't do what you want in the way that you describe, that is, with a
formula. Have a look at conditional formatting. That will do what you
want.

Assume that your invoice dates are in column C, starting in row 2. In Cell
D2, or whatever:

Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd"

Change the format as required, for example, Format | Patterns = green

Copy the formatting to the other cells you want to highlight.

Regards

Trevor


"Feeta" wrote in message
...
I want to use an IF statement to check for text in a cell range and if
true,
then fill a cell with a highlight color. In my application, I would look
for
"PD" in invoice date fields and if found, highlight the amount invoiced in
green. I don't know the snytax to write the return value as "fill this
cell
with color".