Hi there,

I have 2 questions for anyone who can help:

1. How can I activate the option that makes Excel show me the syntax model
of a formula/function I want to introduce in the address bar?

2. How can I filter only the rows with a particular color(e.g. want to
select only the rows formatted with green background)
I'd be grateful if you can send me any solution on my email address:



Thank you.

1.
From your address bar type: =SUM( then press CTRL+SHIFT+A

2.
Copy the entire column into a spare column
Find/Replace the colour green and relpace with value 1
Then autofilter that column by the value 1


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Emil Gaman" <Emil wrote in message
...
Hi there,

I have 2 questions for anyone who can help:

1. How can I activate the option that makes Excel show me the syntax model
of a formula/function I want to introduce in the address bar?

2. How can I filter only the rows with a particular color(e.g. want to
select only the rows formatted with green background)
I'd be grateful if you can send me any solution on my email address:



Thank you.