Hi there
I know that I can achieve what I'm trying to do pretty easily in later versions of Excel using conditional formatting, but i'm apparently making life hard for myself and trying to do this in Excel 2000.
excel.JPG
How I want the above set up is as follows:
When I enter the letter a, e, t o or I into a cell between H5 and H70, the cells in that row change colour accordingly. Below is the code i'm using:
Now I know that I could technically just copy and paste this 70 times and use the same code for each of the 70 rows I want it to apply to, but surely there's a quicker way?Please Login or Register to view this content.
Possibly an incredibly novice question but hey, I'm nothing if not a novice :P
Hope you can help
Moderators note: Code tags added for you -- this time
Bookmarks