Using either 'Conditional Formatting or VB' to color specific Cells

  • Thread starter Thread starter jsaintjohn1
  • Start date Start date
J

jsaintjohn1

All,
I'm new to using macro's within Excel, please forgive my ignorance in
advance! heh
Does anyone know the best way to color cells within a worksheet based
on data in other rows within the same worksheet? I've used Conditional
Formatting but it only lets me use (3) colors. I need to use about 10
or so.
Basically I have data in columns A - P, in columns AI:AJ I have data
that I want to show as a specific color in rows A - P if it exists.
Can someone give me an example that I can use and modify to do this
task?

Thanks
-J
 
I assume that you want an easy way to visually identify certain conditions
in your spreadsheet. A macro certainly could do this. But you would need to
write and maintain the macro, which will take a lot of time.

Instead, here are two other approaches that you might consider:

First, define a condition using a CHOOSE function linked to a cell in your
spreadsheet. When you enter 1 in a cell, cells that match that condition
turn red; when you enter 2, those cells turn red, and so on.

Second, instead, insert a column to the left of each column in your data
range. Use a formula to return, say, "A" for the first condition, "B" for
the second condition, and so on. That way, you can look for the A's and B's
that mark the values you need.

Regards,

Charley Kyd
ExcelUser.com


Rather than changing the formats,
 
For a macro solution you can probably use a Change Event
Macro -- meaning you make a manual change to the cell,
not a change based on a formula.
http://www.mvps.org/dmcritchie/excel/event.htm#case
installed by right-click on worksheet tab, view code, plop your coding in.

For a solution that works like to regular conditional formatting
you can use this addin,
xtended Conditional Formatter «Excel addin«, Bob Phillips & Frank Kabel,
http://www.xldynamic.com/source/xld.CFPlus.Download.html
addin that makes it possible to enter up to 50 conditions with the same entry type panels as builtin Conditional Formatting. Note
this is Beta software (testing not production). (posted 2004-11-07)
http://google.com/groups?threadm=#[email protected]
 
Back
Top