Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Filtered Rows - Change Font Color Of Row Number

Status
Not open for further replies.

FletchUK

Programmer
Nov 6, 2001
16
0
0
GB
Hi everyone,

We all know that when you apply a filter to a Microsoft Excel spreadsheet the row numbers change to blue to indicate that filters have been applied. Is it possible to alter this so they change to red instead?

Thanks,
FletchUK

There are 10 types of people; those that understand binary and those that don't.
 
Aren't there 11 types of people; those who understand binary, those who don't, and the ones who prefer Hex?
[rofl]

Chris

Varium et mutabile semper Excel
 
sorry but nope - that part of excel does not open itself up to the VBA object model

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top