Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
what is the formula that is used if any to color code a cell or many cells
that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Thank you Pat Mineard |
#2
![]() |
|||
|
|||
![]()
The feature to do this is called Conditional Formatting
Highlight the cells you wish to format, then do Format ConditionalFormatting CellValueIs LessThan 0 Format PatternsTab select a color OK OK Vaya con Dios, Chuck, CABGx3 "Pat Mineard" <Pat wrote in message ... what is the formula that is used if any to color code a cell or many cells that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Thank you Pat Mineard |
#3
![]() |
|||
|
|||
![]()
It's called "Conditional Formatting".
You can look it up in the Help files. As an example, select A1 to A5, with the focus in A1 (colored white). Then, <Format <Conditional Format Change "Cell Value Is" to "Formula Is", and enter this formula: =A1<0 Then click on "Format", and choose whatever format or pattern color you wish. Then <OK <OK. Now, A1 to A5 will change to the format you chose when either of the cells is negative. Key in a negative value or enter a formula that will return a negative value and test it out. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pat Mineard" <Pat wrote in message ... what is the formula that is used if any to color code a cell or many cells that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Thank you Pat Mineard |
#4
![]() |
|||
|
|||
![]()
"Pat Mineard" wrote:
what is the formula that is used if any to color code a cell or many cells that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Probably best to use Conditional formatting. Select the range, click FormatConditional Formatting then set the condition cell value less than 0 and choose the font and cell colour you require |
#5
![]() |
|||
|
|||
![]()
Hi,
It depends on your criterian for color-coding cells. Scenario 1: If every cell were to get color-coded when its content reaches a negative value, (1) Select those cells (if those cells or non-contiguous, keep the CTL key pressed while selecting them), (2) Click 'Format' in the toolbar-- 'Conditional Formatting...' (3) In the Conditional Formatting window click the triangle on the right-hand side of 'between', select 'less than', and enter 0 in the right side bar, (4) Click 'Format' near the white strip saying 'No Format Set', select 'Patterns', pick the color you want for color-coding the cells, click 'OK', and 'OK' again. OR Scenario 2: If you want an entire row, or a set of rows/cells (even non-contigues) color-coded when the value in a particular cell (e.g., A12) turns negative, (1) As in Scenario 1, (2) As in Scenario 1, (3) In the Conditional Formatting window, click the triangle on the right-hand side of 'Cell Value Is' and select "Formula Is', and in the right-hand side whilte strip enter the equal (=) sign, click on the deciding cell (e.g., A12), and enter <0 ( the equation would now read as =$A$12<0, (4) As in Scenario 1 Hope this helps. Regards, B.R.Ramachandran "Pat Mineard" wrote: what is the formula that is used if any to color code a cell or many cells that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Thank you Pat Mineard |
#6
![]() |
|||
|
|||
![]()
You can go to: Format, Condition Formatting, set the rule less than $0, set
color to red or your desired color, and ok. That should solve your problem. GT "Pat Mineard" wrote: what is the formula that is used if any to color code a cell or many cells that the amount reaches minus within a spreadsheet, such as total is -$5.69 in a roww and you may have others that may go in the minus How can you color code that cell and others if the amount reaches a minus? I would really appriciate any help because I am working on a expenditure report Thank you Pat Mineard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
how many characters i can put into one cell in Excel | Excel Discussion (Misc queries) | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions |