Thread: Conditional formatting

I have a tricky conditional formatting question. I know this can only be done with a macro as I need more than 3 conditions, but because of other criteria the answers I've found on the forum so far do not quite work for me. I am setting up a spreadsheet for another user who is running Excel 2003. Details are as follows:
- There is a range of cells A13:Z112 currently, but the user needs to be able to insert or delete rows as necessary without screwing things up.
- If column AA reads "EXT" then that row from A:Z needs to turn light orange (col index=40)
- If column AA reads "BUS" then the text in that row from A:Z needs to turn red (col index=3) and also be in italics. No background colour.
- If column AA reads "SP1" then that row from A:Z needs to turn light yellow (col index=19)
- If column AA reads "SP2" then that row from A:Z needs to turn light green (col index=35)
- If column AA is blank, then nothing changes
ALSO...
Within this range, text in columns A, J, N, Q and X must always be bold (so if column AA reads "BUS" then text must be red, bold italic. Or if nothing in column AA then the only change is bold text). I think this probably means having one set of formatting rules for columns B:I, K:M, O:P, R:W and Y:Z and a different set to account for the same formatting PLUS bold text for columns A, J, N, Q and X.
Also, remember that the range won't stay at A13:Z112, the user must be able to insert or delete rows as necessary without mucking things up.
I think that's it, can anyone help me?

Why don't you download Bob Phillips's free CFPlus addin available here:

http://www.xldynamic.com/source/xld.....Download.html

This will give you up to 30 conditional formats instead of the usual 3 in XL2003.

Hope this helps.

Pete

Why don't you download Bob Phillips's free CFPlus addin available here:

http://www.xldynamic.com/source/xld.....Download.html

This will give you up to 30 conditional formats instead of the usual 3 in XL2003.

Hope this helps.

Pete

Thanks.

If I install the plugin on my computer and make the changes, will it work on another computer or will they need the plugin installed also? I'm creating this spreadsheet for another user...

Hi Jen,

yes, they will also need to install the addin on their machine (but it's free !!)

Pete

Thanks a lot, I appreciate the help.

A macro would still be the preferred option, so if anyone out there knows how to and can spare the time to write me one for this scenario, I would really appreciate it.

Thanks!!

Ok so I installed this add-in, it kind of works. It applies the formatting to only some of the rows in the selected range. It's like there is a limit to how many rows the formatting will work for...

If you follow that link to Bob's site, then in the header you can click on General and from there you can contact him directly via email. I've not installed the add-in, so I can't comment on any restrictions.

Hope this helps.

Pete