Find text, get number and color cell green

Closed
Broholm - Apr 27, 2009 at 12:54 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 28, 2009 at 02:26 AM
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.

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Apr 28, 2009 at 02:26 AM
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 ....
6