How to highlight a row containing specific phrase?
Use conditional formatting with a formula of
=SUMPRODUCT(--(ISNUMBER(FIND("TODO",1:1))))0
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Barb Reinhardt" wrote in message
...
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
|