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?
Printable View
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?
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?
that worked great, thanks! :)
Glad to help.
If this issue is closed, please mark your thread resolved using the thread tools menu. :thumb: