Excel, Marking a field when text is not like required
you could use Conditional Format on A2.A999
use 'formula is' and
=NOT(OR(A8="aaa",A8="bbb",A8="ccc"))
set a pattern color as required
Patrick Molloy
" wrote:
Hello,
I like to have a module which marks the datafield, in column A from
record 2 till last, in color red when the registered data is not equal
to "aaa" or "bbb" or "ccc".
Can you help me out.
Johan
|