Thread
:
activate excel tooltip
View Single Post
#
2
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_]
external usenet poster
Posts: 1,236
activate excel tooltip
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.
Reply With Quote
Rob van Gelder[_4_]
View Public Profile
Find all posts by Rob van Gelder[_4_]