|
-
Jun 5th, 2006, 08:33 AM
#1
Thread Starter
Member
Conditional Formatting - multples from vba
Mornin all. ;0
I have a range of cells and a variety of conditions that I'm trying to create.
Specifically, if a number is below a range, do nothing, if it's within a range, I need to to change the font and color, and if it exceeds a range, I need it to change font and color yet again. (bold/orange and bold/red respectivly)
and I need to do this 22 times, once per row in range j6 27
I tried various combinations (wish I'd saved the code) but all I could get was an effect that turned everything black.
Can someone please help me with this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|