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

  • Thread starter Thread starter cocoblue
  • Start date Start date
C

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
 
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
Click to expand...

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
 
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
Click to expand...

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