I would like to know that how do i change font color in a range on Excel 2007. Let say for example if i would like to create a worksheet in order to calculate money. If i get any negative amount then Excel should display the number in 'Red', while if it gives out positive number then it should display the number in 'Green'. Can any body tell me that how can i do it? Does any body knows about it? Kindly provide me the correct solution for the above issue.