View Single Post
  #4   Report Post  
k11ngy k11ngy is offline
Junior Member
 
Posts: 2
Default

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 View Post
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
Attached Images