Try this condition:

=SEARCH("TODO",$A1)0

$A1 is where the data is stored. You can select Column A,B, and C and enter
this and you'll get the entire row shaded if "TODO" is in A1.

If you want to look at data in multiple rows (say A-D), change the condition
to

=SEARCH("TODO",$A1&$B1&$C1&D1)0


"Josef Vosyka" wrote in message
...
For example I need to highlight all rows containing 'TODO' anywhere in the
text.
I've tried conditional formating with formula condition '=FIND("TODO";)1'
but failed.
I'm looking for 2 answers:
1) how to represent the current cell reference in the formula. Is the
simple
omitting (as shown above) correct?
2) how to apply the format to the whole row, not just to the cell meeting
the condition?

Thank in advance for your help!
--Josef