Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Nuno Jácome said:
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 ?
Click to expand...

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 any way

"jbtenor1" escreveu:
 
"jbtenor1" escreveu:
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?
Click to expand...

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

Thanks anyway
 
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
 
I'm not un expert, so I will try to explain again.
In the D12 cell I have a list (Invoice, credit note, Debit note, etc).
In the cell K12 I have a number (curency format €).
I want if D12 as select Invoice or (more than 3) K12 will appear red.
I can do it till 3 times like this: =D12="invoice"
I try your suggestion and it don't work because (I think) I put
=D12=OR("invoice","credit") if I put =OR("invoice","credit") it don't work
too because the cell K12 have a number to be colored if D12 as "invoice" or
"credit" or ..........

Thanks any way


"roadkill" escreveu:
 
Back
Top