automatic text highlighting

  • Thread starter Thread starter Glennh
  • Start date Start date
G

Glennh

Hi folks,

I use a spreadsheet that automatically changes the font color of the row
to red if the text in a particular cell = fail.

My problem is it's not working consistently (because of my editing the
spreadsheet I expect) and I CANNOT find out how it's done.

There's no macro and no hidden cells that I can find that perform this
text coloring task.

Has anyone an ideas of how it's been done?

Thanks

Glenn
 
Glenn,

Mark the area where you want this applied, and then go Format > Conditional
Formatting. The rest is self-explanatory.

HTH,
Nikos
 
Hi Glenn,
Try using TRIMALL on a selection, code will limit selection
to the used range. Strips leading, trailing spaces, duplicate
inner spaces (depending on which TRIM is used). Converts
non-breaking spaces to spaces -- .Char(160) to Char(32).
http://www.mvps.org/dmcritchie/excel/join.htm#htm

You don't say what you are using nor your formula or code,
so will assume you are using Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If the word stands by itself and is not case sensitive
then the formula used might be
=TRIM(A1)="fail"
if the word is embedded in additional text and not case sensitive,
you might use
=SEARCH("fail",A1)
If you are looking for a case sensitive Exact match.
=EXACT("fail",A1)
If you are looking for "fail" anywhere in the entire row
=COUNTIF(1:1,"fail")

Remember the formula used is based on the active cell,
and coloring or other formatting is based on the cells, or
columns selected.
 
Back
Top