Datasheet Formating

C

Confused Slug

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.
 
K

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.
 
M

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
 
Top