On the main menu select
Format -- Conditional Formatting...

The window that pops up will make it pretty clear how to set that up.
And you can click the "Add" button to get up to three tota
conditional formats. - Piku

--
Message posted from http://www.ExcelForum.com