Datasheet Formating

[Guest]

Is it possible to change the format of a cell or cells within a subform when
it is displayed as a datasheet. I have only been able to format the entire
datasheet which is not what a want as i wish to highlight specific data
within the datasheet base on the value in the cell.

 

[kingston via AccessMonster.com]

Try conditional formatting. Select the cell that you want to format, and
from the main menu, select Format -> Conditional Formatting... Then create
your criteria. The format possibilities are somewhat limited, but hopefully
they'll work for you.

 

[missinglinq via AccessMonster.com]

And be aware you can set up to 3 criteria, i.e.
if value = No Fore Color = Red
if value = Yes Fore Color = Green
if value = Null Fore Color = Yellow