Conditional formatting, please help!

[Gixer 1000]

I'm a complete novice to programming or anything too technical, so please be gentle! I have a report that is based on a query. In the main detail section it displays 4 prices from 4 fields in each record. I want to highlight in bold the cheapest of these prices. I also want to highlight all prices that at the same. I first thought of using conditional formatting which would be great, except that it only allows 3 conditions. The other problem is that any one of these fields could have a zero value, meaning that there is no price and it has to be ignored. I would like to display the zero value fields as blanks, with a white foreground and white background. I'm expecting that I may need a VB code solution to this. I don't have a clue how to code it, so any help would be really appreciated!

 

[voslica]

I'm a complete novice to programming or anything too technical, so please be gentle! I have a report that is based on a query. In the main detail section it displays 4 prices from 4 fields in each record. I want to highlight in bold the cheapest of these prices. I also want to highlight all prices that at the same. I first thought of using conditional formatting which would be great, except that it only allows 3 conditions. The other problem is that any one of these fields could have a zero value, meaning that there is no price and it has to be ignored. I would like to display the zero value fields as blanks, with a white foreground and white background. I'm expecting that I may need a VB code solution to this. I don't have a clue how to code it, so any help would be really appreciated!

I am needing this answer as well. Did you find a fix for this problem?

 

[Gixer 1000]

No, still waiting in hope!