Are you just trying to put multiple tests under one conditional format
condition or are you truly trying to use more than 3 conditional formats (4
if you count the default format)? If you are just trying to conditionally
format using the same format if D12 is either "invoice" or "credit note" then
you can use the formula: =OR("invoice","credit").
- Roadkill

"Nuno Jácome" wrote:



"jbtenor1" escreveu:



"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?

The Machine says: It not possible use unions, interactions, ........

Thanks anyway