-
formatting questions
I need to format a field (cell) the following way:
If the value is greater than 0, then the background color needs to be yellow and the font is red, otherwise the font remains black (or default). Also for this column the format has to be currency.
MC3 = "DSO60,bgcolor=yellow,<FONT COLOR=Red>#dso60#</font>;"
MyDb3.dbMagicCell = MC3
This gives me the correct colors, but doesn't validate the data.
MC3 = "DSO60,,(|GT|0|bgcolor=Yellow);"
MyDb3.dbMagicCell = MC3
Validates the data, but only my background changes color.
How can I combine the two? Or is there better way to do this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|