i would like to to format a cell if it is blank to bright background to bring attention to it
S sfleck Dec 12, 2007 #1 i would like to to format a cell if it is blank to bright background to bring attention to it
S sfleck Dec 12, 2007 #2 I guess setting the default to the color you want will work and changing if the field contains text
F fredg Dec 12, 2007 #3 i would like to to format a cell if it is blank to bright background to bring attention to it Click to expand... Select the control on the form you wish to conditionally format. Click on Format + Conditional Format. Set Condition1 to Expression Is write in the next box [FieldName] Is Null Select the color you wish Save teh changes
i would like to to format a cell if it is blank to bright background to bring attention to it Click to expand... Select the control on the form you wish to conditionally format. Click on Format + Conditional Format. Set Condition1 to Expression Is write in the next box [FieldName] Is Null Select the color you wish Save teh changes
