Can I create more than 3 Condidtional Format conditions or can I w

[cocoblue]

I would like to have a list the if the criteria is TRUE for a list item then
the cell with the list item in is formatted according to the rule.
Is this possible?
cheers

 

[Ron Rosenfeld]

I would like to have a list the if the criteria is TRUE for a list item then
the cell with the list item in is formatted according to the rule.
Is this possible?
cheers

Use a formula like COUNTIF:

e.g.

=COUNTIF(list,cell_ref)

Which should return TRUE or FALSE depending on if cell_ref (your cell to be
formatted) is in 'list'.
--ron

 

[Ron Rosenfeld]

Use a formula like COUNTIF:

e.g.

=COUNTIF(list,cell_ref)

Which should return TRUE or FALSE depending on if cell_ref (your cell to be
formatted) is in 'list'.
--ron

Skip this response -- I misread your question
--ron