Change the background format

[Carlos]

Hi,

My form is designed in datasheet view. I do few
conditional formatting from Format menu (e.g. If value is

15 then change its background color to red)

In the same form, I have a calculated field (txtAverage)
which gets the average of values base on different
criteria. The users want to see or highlight those items
(say field ItemName) where the value of txtAvarage come
from whenever they trigger or focus on txtAverage. This is
somewhat similar to Excel when modifying the formula of a
cell, a series of colored rectangle appears on the cells
or range where the formula refers. Is that possible in
Access? Would it involve complicated coding? I use to
write simple codes in forms but could not imagine how to
do this one.

Any advice will be much appreciated.

Thanks in advance.

Carlos