|
-
May 15th, 2006, 04:07 PM
#1
Thread Starter
Lively Member
 [RESOLVED] Excel VBA
I'm looking for some help on code,
Basically what i want VBA to do is something like this...
If number in cell is 0 - 5 then
the font in the cell is red
if number in cell is 5-10 then
the font in the cell is orange
else the font is green
Any ideas?
-
May 15th, 2006, 04:39 PM
#2
Lively Member
Re: Excel VBA
You don't need vba to do this. You can use conditional formatting.
First select the range you want to apply this formatting to, then go to Format > Conditional Formatting. Here you can apply (multiple) cell formats according to the value of each cell.
Does this suit your requirements?
Last edited by New2vba; May 15th, 2006 at 04:43 PM.
"Those things we must learn to do, we must learn by doing" (or hope somebody else will take pity and help out  )
-
May 16th, 2006, 12:16 PM
#3
Thread Starter
Lively Member
Re: Excel VBA
that worked great, thanks!
-
May 16th, 2006, 12:25 PM
#4
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
|
Reply With Quote