LinkBack URL
About LinkBacks
I have the original number of 1
the second number i calculated to be 0.35
I need to make the second cell highlight if the number is within +0.1 or -0.75
I have the original number of 1
the second number i calculated to be 0.35
I need to make the second cell highlight if the number is within +0.1 or -0.75
Hi
Assuming your data is in A1 (1) and A2 (0.35)...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(A2<=A1+0.1,A2>=A1-0.75) format fill 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks