Serving the Quantitative Finance Community

 
User avatar
paladin
Topic Author
Posts: 0
Joined: December 19th, 2005, 12:41 pm

excel query

July 24th, 2006, 1:22 am

I want to add colour to the cell based on the value for eg. red for all the cells that contain 1 in the worksheet.can somebody help on this..thanks in advance
 
User avatar
afoster
Posts: 5
Joined: July 14th, 2002, 3:00 am

excel query

July 24th, 2006, 5:39 am

Format > Conditional Formatting ....