Conditional Format

[carlos]

Hi,

I have a test results statistical analysis. A form should
be viewed in datasheet. I can set simple conditional
formatting (e.g. if Test <50 then turn its BackColor to
red, etc. ), but I got stuck about this: unbound text
(txtAverage) contains the formula =DAvg
("Test","qryTest", "Record Between " & [Record] & " And "
& [Record] – 3 & "").

I want to set conditional formatting that when I GotFocus
on txtAverage, it will highlight those Test according to
the said formula. Note that Record is AutoNumber. Is that
possible in conditional formatting or do I need to code
it? Please help.

Thanks in advance.

Carlos