Hi, welcome to the forum
Have you looked at using Conditional Formatting for this?
1. highlight the range you want to apply the conditional formatting to (the range in column D)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2<30 format as required
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
No, because I need to automate this for many worksheets on a regular basis. I'm thinking along these lines, but I'm not defining something correctly:
#Dim b As Range
For Each b In ActiveSheet.UsedRange
If b < 30 Then Offset(0, 2).NumberFormat = "?0.0""%*"""
Next b
#
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks