conditional format based on value anywhere in a column

  • Thread starter Thread starter lone pilgrim
  • Start date Start date
L

lone pilgrim

Does anyone on the board have any hints on this:

I am trying to format a cell based on a given value appearing anywher
in a column. Is this possible to do?

Alternately, is there a way to set more than three conditions to forma
any given cell?

Thanks in advance for any help
 
Maybe

=COUNTIF(A:A,cell_to_check)>0

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi
maybe use the following formula in the conditional format dialog
=COUNTIF(A:A,yourvalue)
 
Back
Top