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,
<
[email protected]> wrote in message
news:
[email protected]...
> 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
>
Bookmarks