Search : in
By :

Find text, get number and color cell green

Last answer on Apr 28, 2009 7:26:06 am BST Broholm, on Apr 27, 2009 5:54:40 pm BST 
 Report this message to moderators

Hello,

I am making my own budget and have trouble doing the following:

From my online bank I export all my account activities one month at a time to their own sheet: January, Febuary, March etc.

I have one sheet i call "calculation" which have the months as columns and expenses posts as rows. As an example I have a post called "car insurance". In the cell where this row hits the January column I have the following function:

=SUMIF(January!F:F;"*123456789*";January!D:D)

This gives me the sum of column D when a text in column F matches an account activity with a withdrawel ID of "123456789"

So far so good. What I would like the function to do is:

=SUMIF(January!F:F;"*123456789*";January!D:D) AND In case you find a text matching "123456789" Color that cell on sheet January green.

This way I can check the sheet January and see what rows Excel automatically has summed to my "calculation" sheet.

I hope this makes sense. Hope someone can help. Thanks in advance

Broholm.

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Find text, get number and color cell green » in :
Transforming a color to digital value ShowTransforming a color to digital value You can make use of this macro to get the color code: Sub distri_color() Dim i For i = 1 To 12 Worksheets(1).Range("C" & i).Value = Worksheets(1).Range("B" & i).Interior.Color Next...
VBA: How to know everything about the file folder ShowVBA: How to know everything about the file folder Preliminaries In module In sheet1 module Preliminaries Open a new workbook Add a module In module ' Declare variables for wizard. Public balloon1 As Balloon Public balloon2...
[C Language] finding the square root of a number Show[C Language] finding the square root of a number Intro Notes Intro A simple C program allowing you to find the square root of a number. #include #include int main(void) { double x = 4.0, result;...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Representation of real numbers and integers ShowRepresenting a number in a computer Representing (or encoding) a number means to express it in binary form. Representing numbers in a computer is necessary in order for it to be able to store and manipulate them. However, the problem is that a...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...
Ask your question Reply

1

 mubashir aziz, on Apr 28, 2009 7:26:06 am BST
  • +3

Now in Months sheet you have to use conditional formatting comparing it with your calculation sheet. but for this you have to given your ranges a name .......... actually its hard to define rather than if i have a sample file ....

   
Reply to mubashir aziz
Ask your question Reply
They need your help