"Nuno Jácome" wrote:

Condictional formatting have 3 condictions available.
I need more because:
The cell D12 have a list (name Documents - invoice, credit note, debit note,
... more than 3). when I try to make on cell K12 a conditional formatting,
formula D12="Invoice" it works, but when I try D12="invoice" or "credit note"
.... it don't work.

please could anybody help me ?

If you put your list of all the values in another column, you can then have
D12 refer to a Range of cells instead of just one. Put your "like" items in
a group, then have the formula work like this if your new column is in G.

"Invoice" is in G2 and "credit note" is in G3

Formula D2=$G$2:$G$3

Will this help?