Find text, get number and color cell green

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

1 response

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