Macros & Conditional Formatting

[diddymacs]

I have created a spreadsheet which contains a list of approximately 500 clients and their associated ranking (A, B, C, etc). The rankings are listed in Column A and the client name in Column B.

I would like to create buttons that when pressed will hi-lite the client names based on their ranking ("Button A" hi-lites all A clients, "Button B" hi-lites all B clients, etc.)

I'm pretty comfortable inputting formulas/conditional formatting but don't have much experience with macros.

Any help is greatly appreciated!

 

[Jerry Sullivan]

Welcome to the Board!

The Conditional Formatting formula could do most of the work.
The screen shot below shows one approach...

Excel Workbook
	A	B
1	B
2
3	Ranking	Client
4	A	Alpha
5	B	Baker
6	C	Charlie
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4	1. / Formula is =$A$1=A4	Abc

Your macro just needs to write A, B or C into Cell A1.
Range("A1")="B"