Is there a "formula" or a way of "formatting" a cell...

[ShannonJ]

Is there a "formula" or a way of "formatting" a cell or even the entire column -- to automatically have the cell highlight (as in the yellow highlight button) if the sum is $0 (or less that $1)?

I noticed while entering many spreadsheets worth of data that it will automatically pick-up and highlight the cell on its own if the amount I entered was less than $1.....which made me think that has to be a way to enter that kind of formula, right? Only problem is I don't know how to do this ...so sometimes it'll pick it up on its own and highlight the cell yellow as the ones before it, but not in every case....any help would be greatly appreciated.

Thanks so much in advance!

 

[VoG]

Hello and welcome to MrExcel.

Take a look at Conditional Formatting http://www.contextures.com/xlCondFormat01.html

 

[Gettingbetter]

Hi Shannon,

welcome to the board.

Highlight the column and (from the toolbar) click Format, Conditional Formating

Then follow the instructions

Cheers
GB

 

[ShannonJ]

Hey thanks so much Gettingbetter....but i dont see where it shows where I can highlight the cell, it'll let me change the font color, but not highlight...am i doing something wrong?

 

[Gettingbetter]

You can change the Font colour because you are on the Font tab,

along the top of the window there are three tabs Font, Border and Pattern

Its the tab Pattern that changes the colour of the cell

Cheers
GB

 

[ShannonJ]

Thank you so much everyone!! Have a GREAT DAY!!