Hi Neal,

There is no way of having both that I am aware of. However, it might be
worth while placing a new question on this forum because I have been wrong
before and no doubt I will be in the future. To the best of my knowledge
conditional format over rides any other format and therefore you have to
delete the conditional format first. To delete conditional format from a
cell:-

Click on the cell.
Select the menu item Format
Select Conditional Formatting-Delete button
Then check the box for the level to delete. (In your case it will be
condition 1)

If there is no other formatting in the cell, you can simply use Clear
formats. However, it takes out all formatting including bold and number/date
formats etc and returns it to the 'General' format state. To do this:-

Click on the cell
Select menu item Edit
Select Clear- Format

If the above is a viable option then I suggest that you place a button on
your toolbar for 'Clear Format'. To do this:-

Click on menu item View-Toolbars-Customize.
Select Commands tab if it is not already displayed.
Select Edit in the left column.
Find 'Clear formatting' in the right column.
Click on 'Clear formatting' and drag the button to any place you like on
your toolbar.

Regards,

OssieMac