Colouring cells automatically

[broncos347]

I have a spreadsheet which monitors call costs for our company and what i would like to be able to do is to have a formula which could highlight (in a different colour) which cell contains the highest cost for a particular month.

Any help would be appreciated.

 

[Peter_SSs]

broncos347

Suppose that the costs for the month are in cells B1:H5
1. Select B1:H5
2. Use menus as follows Format|Conditional Formatting...|Formula is =B1=MAX($B$1:$H$5)
3. Click Format to select the colour
4. OK,OK

 

[Brian from Maui]

I have a spreadsheet which monitors call costs for our company and what i would like to be able to do is to have a formula which could highlight (in a different colour) which cell contains the highest cost for a particular month.

Any help would be appreciated.

Depending on your setup, and using Conditional Formatting, you can try either the MAX or LARGE function. If you can be more specific, I'm sure someone can help you!

 

[Smitty]

You can/should be able to do that with Conditional Formatting (Format-->Conditional Formatting), but can you give an example of your data?

Smitty