How to control check mark colors.

[Eloise T]

The uploaded Excel file has two Columns (C and L) of currency numbers that need to match.
If Columns C and L match, the formula is instructed to do nothing.
If they don't match the formula in Column O puts a check mark (really a sq. root char.)
in Column O.

If the dollar amount in Column C is greater than Column L, the check mark should be green.
If the dollar amount in Column C is less than Column L, the check mark should be red.

Currently, the check mark appears in Column O when there is a mismatch like it should, but the colors aren't being engaged via the Conditional Formats that the macro is creating, so the check mark remains black. The check mark appears in the macro courtesy of the Named Manager (CheckMark).

Suggestions? Help?

 

[NARAYANK991]

Hi ,

See if this is acceptable ; I haven't made use of the named range.

Narayan

 

[Debaser]

Just FYI, you don't need the IF statement in those CF formulas - simply use:

=AND($C7>$L7, O7 = "ü")

for example, rather than:

=IF(AND($C7>$L7, O7 = "ü"), 1, 0)

 

[NARAYANK991]

Just FYI, you don't need the IF statement in those CF formulas - simply use:

=AND($C7>$L7, O7 = "ü")

for example, rather than:

=IF(AND($C7>$L7, O7 = "ü"), 1, 0)

Hi ,

Logically , the first one should be sufficient , but I have seen cases , I am not able to recall at present , where it did not work in CF , while the second one did.

As a matter of practice , I use the second version now , and it always works.

Narayan

 

[Debaser]

I would be very interested to see one if you can locate or recall it. I have never encountered one and would be very surprised to, given that AND natively returns a TRUE/FALSE whereas 1/0 has to be coerced to the same. It would certainly be worth filing as a bug if it can be reproduced (although if it's an obscure set of circumstances to cause it, I doubt it will get much traction to fix).

 

[Eloise T]

Hi ,

See if this is acceptable ; I haven't made use of the named range.

Narayan

You made a clever use of Wingdings!

How do I get rid of the mailboxes in Column O starting in Row 21?

 

[KenU]

If you want VBA to put set a cell value to a check mark, you could try the following (will not work on Mac versions).

ActiveCell = ChrW(10004)

Hope that helps.

Regards,
Ken

 

[Eloise T]

Hi ,

See if this is acceptable ; I haven't made use of the named range.

 

[Eloise T]

What character is 10004?

 

[KenU]

It is a check mark using a unicode extended character set.

 

[Eloise T]

Aha!