Excel Wizards Help!

[cmorrison6]

I have an excel spreadsheet of a list of Items I am looking for. Once i find them I am highlighting the whole row green.
Is there a way of having cell which automatically updates the number of green rows I have. i.e. if I have found 55 and I highlight another one green, it then automatically updates to 56?

I hope that makes sense.

Cheers

 

[MarcoB]

You can create a macro, use the help section it can be useful.

 

[iain187]

you could add an extra column where you write 'yes' if the row meets your criteria
then you could use conditional formatting to highlight the row if the cell = yes
and finally use a count function to count the amount of yes'es (sp!)

i dont like macro's when they can be avoided.

 

[AK]

you could add an extra column where you write 'yes' if the row meets your criteria
then you could use conditional formatting to highlight the row if the cell = yes
and finally use a count function to count the amount of yes'es (sp!)

i dont like macro's when they can be avoided.

+1 exactly the way i would do it!

Macros are messy!

 

[edryn80]

Search COUNTIF.

If your searching and highlighting you can always use 'Conditional formatting' to do it for you.


Exactly what iain said then! Read fail...

 

[Paddy_g46]

Macros FTL! Do what was said above!

 

[Invexis-]

you could add an extra column where you write 'yes' if the row meets your criteria
then you could use conditional formatting to highlight the row if the cell = yes
and finally use a count function to count the amount of yes'es (sp!)

i dont like macro's when they can be avoided.

Best way.

Also with this 'additional coloumn' perhaps hiding it would be better too?This way your not having more visible figures/wrighting cluttering up the page.

 

[iain187]

if it is possible to write an if statement on which rows are green you don't even need th column

 

[AK]

Infact.. do you need to use colours :S

Could just have a count if set up for all the ones that you add a yes too..