I seem to have problem, I managed to get code right I think but I just get the word RED and not the Age formatted to red, can anyone help?
Regards
Steve
Quote:
Originally Posted by Steven Teslic
Hi Peter. This is essentially what I am having trouble with as well. I will have several seperate columns that will equal 1 or 0 depending on where a bottle needs to be shipped. Essentially, I will be wanting column F to appear highlighted in a specific colour based on columns I through L having a 1 or 0 entered in them. So I follwed the coding below e.g. If myfieldF =1 mergefield myfieldI blah blah. Which appeared to work. However, it did not work when I simple entered a space, and started the pattern over for the 5 other remaining colours I would need to designate statements for.
Is there anything special I need to do to string all of the commands together? or just enter a space and try repeating this pattern 5 more times?
Thanks,
Steve
|