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 :
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
Text String count within a Cell ShowText String count within a Cell Issue Solution Note Issue I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific text string within each cell entry? e.g....
[C language]Checking whether an integer is a prime number Show[C language]Checking whether an integer is a prime number Definition of a prime number Algorithm 1: dividers between 2 and N-1 will be tested Algorithm 2: Even dividers will not be tested, research is limited to odd dividers Algorithm 3:...
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...
Spreadsheet - Text Operators ShowConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell...
Ask your question Reply

1

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

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