I am attempting to automate errors in data using conditional formatting. My intent is to automate highlighting errors when cell data vary. Highlight cell F2 if F2/B2 > 1.5 I've tried several formula variations and cannot get this right. Any formulas that have worked for you?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Dividing across two colums with highlights in Conditional Formatting
- Thread starter mdenyszyn
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,175
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
Use the "Formula" option for Conditional Formatting and use the formula:
Note that if B2 can be zero or empty, you may need to account for that error, i.e.
Use the "Formula" option for Conditional Formatting and use the formula:
Code:
=F2/B2>1.5
Code:
=IF(B2<>0,F2/B2>1.5)
Last edited:
Upvote
0
Similar threads
- Question
- Solved
- Solved
