View Single Post
 
Old 05-01-2010, 08:56 AM
Kristiina's Avatar
Kristiina Kristiina is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2010
Posts: 58
Kristiina is on a distinguished road
Default

In order to get the conditional formatting to work you have to first select the data you wish to format and then choose the conditional formatting button. From the second list choose "Equals to" and type for an example TRUE. From the "Format" button choose the color of your liking. To get the tool to color the "FALSE" cells in a different color, choose the conditional formatting again and do the same procedure all over except next to "Equals to" type FALSE.

Hope this helps.

Rgrds,
Kristiina
Reply With Quote