Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 21st 07, 08:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 1
Default Total column changes colors when total equals sum of other columns

I have set up a column that will have invoice total. Then have other columns
that are the "parts" of the total. IE: total invoice $100.00 (I type in
this total). Next columns 3 columns include the parts that equal the total
invoice. Say like $50, then $30, then $20. I want the total (ie $100.00) to
display in "red" until I enter the next 3 columns and then it will change to
"black font color" only if my totals in the 3 columns equals $100.00

  #2   Report Post  
Old April 21st 07, 09:00 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 461
Default Total column changes colors when total equals sum of other columns

Alright, if I get what your saying this should work. Suppose you have your
total in Cell A10. Set the color to red yourself. Then follow these steps.

1) Select cell A10
2) Go to---- Format --- Conditional Formatting
3) Change the "Cell Value Is" to "Formula Is"
4) Type in this formula exaclty =A10=SUM(B1010)
5) Change the format to whatever color you want (Black in your case)
6) Press OK

Now if your totals in Cells B1010 equal 100, the font will change from red
to black. Let me know if this helps.

"newstacy" wrote:

I have set up a column that will have invoice total. Then have other columns
that are the "parts" of the total. IE: total invoice $100.00 (I type in
this total). Next columns 3 columns include the parts that equal the total
invoice. Say like $50, then $30, then $20. I want the total (ie $100.00) to
display in "red" until I enter the next 3 columns and then it will change to
"black font color" only if my totals in the 3 columns equals $100.00



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
Changing colors of a formula total. Martin Excel Discussion (Misc queries) 2 March 8th 07 03:01 AM
disable Total and/or Sub total for a single column Voyager Excel Worksheet Functions 3 February 14th 07 10:51 PM
If cell equals, give total of another cell Lori Burton Excel Discussion (Misc queries) 1 January 12th 06 03:48 PM
in excel just want to add 4 columns and total in next column michael_l Excel Worksheet Functions 3 April 8th 05 11:13 PM
XL formula - total of row = total of column topaz Excel Worksheet Functions 2 March 17th 05 10:04 PM


All times are GMT +1. The time now is 01:53 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017