software

I'm trying to figure out if graphical indicators can be used with conditional
formatting. I want to do more than just color the font or fill the cell.
--
Chris Campana

Check out the different font types such as Wingdings, Marlett, Webdings.
These are symbols instead of alphabetic characters. You can conditionally
change the font colour from being the same as the interior colour (symbol
therefore hidden) to the desired colour (symbol visible).

Regards,
Greg

quot;Chris Cquot; wrote:

gt; I'm trying to figure out if graphical indicators can be used with conditional
gt; formatting. I want to do more than just color the font or fill the cell.
gt; --
gt; Chris Campana

Thanks for the tip Greg, but I guess my Excel knowledge is not completely up
to par. I thought that for conditional formatting to work, there has to be a
value in that specific cell that meets the criteria to be conditionally
formatted. If I insert a symbol (non-text, non-numeric character), how do I
set the conditional formatting for a non-alphanumeric character in that cell.
Do I need to reference another cell or do some type of lookup? (i.e. the
result of a formula appears in B10, if that result is greater than or less
than the value in A10, format the cell in C10 to show a Wingding with
different font and background color).
--
Chris Campanaquot;Greg Wilsonquot; wrote:

gt; Check out the different font types such as Wingdings, Marlett, Webdings.
gt; These are symbols instead of alphabetic characters. You can conditionally
gt; change the font colour from being the same as the interior colour (symbol
gt; therefore hidden) to the desired colour (symbol visible).
gt;
gt; Regards,
gt; Greg
gt;
gt; quot;Chris Cquot; wrote:
gt;
gt; gt; I'm trying to figure out if graphical indicators can be used with conditional
gt; gt; formatting. I want to do more than just color the font or fill the cell.
gt; gt; --
gt; gt; Chris Campana

BTW, the characters ARE alphanumeric. It's just that when they are formatted
as one of these font types they appear to be symbols. For example, the letter
quot;aquot; in Marlett appears to be a checkmark. The letter quot;nquot; in Marlett appears
to be a big dot. There is a technique for making your own checkboxes using
Marlett and the letter quot;aquot; that, unlike using real checkboxes, requires no
maintenance if the amount of data changes.

Example of using conditional formatting in conjunction with Marlett font to
flag dates that have expired:

a) Select cells C1:C10.
b) Select Format gt; Cells gt; Font tab.
c) Select Marlett from the list of font names.
d) Select the Color dropdown and select white (same as cell interior).
e) Close the dialog.
f) Select Format gt; Conditional Formatting (with C1:C10 still selected).
g) Select quot;Formula Isquot; in the dropdown.
h) Enter the following formula in the formula window:
=AND(B1gt;0, B1lt;TODAY())
i) Click the Format button (the Format Cells dialog will appear).
j) Select the Font tab.
k) Select the Color dropdown and select red from the color palette.
l) Click the OK button to close the dialog.
m) Click OK again in the Conditional Formatting dialog to close.
n) Enter the letter quot;nquot; in all cells in C1:C10.

Now enter dates in the range B1:B10. If these dates are less than today then
a red dot will appear in the adjacent cell in column C indicating expiry.
Note that the above formula is relative and will always reference the
adjacent cell in column B.

Example of how to view the different symbol options:

a) Enter the following formula in cell A1:
=CHAR(ROW())
b) Drag the formula down to cell A255.
c) Now format this range with different font types, particularly:
Marlett, Wingdings (3 series), Webdings, Map Symbols.

Regards,
Gregquot;Chris Cquot; wrote:

gt; Thanks for the tip Greg, but I guess my Excel knowledge is not completely up
gt; to par. I thought that for conditional formatting to work, there has to be a
gt; value in that specific cell that meets the criteria to be conditionally
gt; formatted. If I insert a symbol (non-text, non-numeric character), how do I
gt; set the conditional formatting for a non-alphanumeric character in that cell.
gt; Do I need to reference another cell or do some type of lookup? (i.e. the
gt; result of a formula appears in B10, if that result is greater than or less
gt; than the value in A10, format the cell in C10 to show a Wingding with
gt; different font and background color).
gt; --
gt; Chris Campana
gt;
gt;
gt; quot;Greg Wilsonquot; wrote:
gt;
gt; gt; Check out the different font types such as Wingdings, Marlett, Webdings.
gt; gt; These are symbols instead of alphabetic characters. You can conditionally
gt; gt; change the font colour from being the same as the interior colour (symbol
gt; gt; therefore hidden) to the desired colour (symbol visible).
gt; gt;
gt; gt; Regards,
gt; gt; Greg
gt; gt;
gt; gt; quot;Chris Cquot; wrote:
gt; gt;
gt; gt; gt; I'm trying to figure out if graphical indicators can be used with conditional
gt; gt; gt; formatting. I want to do more than just color the font or fill the cell.
gt; gt; gt; --
gt; gt; gt; Chris Campana