Sue has attended:
Excel Advanced course
Access Advanced course
Access VBA course
Format
how do i conditional format
RE: format
Sue
To apply a format condition to a cell or range of cells, first select the range to which you want to apply the format condition, then open the Conditional Formatting dialog from the Format menu.
Next, change the between operation to which ever operation you want. Next, enter the value or values for that condition. Finally, click the Format button on the dialog box. You'll see the standard cell formatting dialog. Not all format items are available in Conditional Formatting. For example, you cannot change the Font or Font Size with Conditional Formatting. Once you have select your format, click the OK button.
hope this answers your question
regards
david