What you are looking for is probably a perfect example of why "Conditional
Formatting" was instituted.
Besides just making your ticks red, you could also make the cell yellow.
That would really stand out!
Check it out in the help files, and post back if you need any additional
assistance.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
am looking for possible work-arounds to a similar problem
I use an IF formula to output a "-5" (negative five, integer) if my
criteria are not met. I then format the cell using
FORMAT CELLS>>NUMBER>>NUMBER>>NEGATIVE NUMBER>>OPTION 2
(that is, a negative number is displayed in red without the leading
"-" sign or trailing decimal spaces).
Using the monotype sorts font meant i saw a red "X" in cells that did
not meet my criteria. Easy to pick out in a long list and where the
cells that do meet my criteria are black tick marks, Monotype Sorts,
4.
Tickmark and crossmarks in Wingdings/Webdings fonts use alphabets &
special characters so the above trick will not work. Any suggestions
for a work-around?
Thanks in advance
Dar