Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pat Mineard
 
Posts: n/a
Default how to color code a cell in excel if amount reaches a minus

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   Report Post  
Ragdyer
 
Posts: n/a
Default

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   Report Post  
bigwheel
 
Posts: n/a
Default

"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   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

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   Report Post  
George Teng
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 12:07 PM
how many characters i can put into one cell in Excel Gary Excel Discussion (Misc queries) 2 May 18th 05 03:08 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 07:19 PM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 04:41 AM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 09:57 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"