Hello,
I'm trying to use conditional formatting to see if the sum of 2 different cells equals the value in a third. In basic terms, I want the excel formula for 'If(L6+M6=I6), then turn the cell green'.
Thanks!
Hello,
I'm trying to use conditional formatting to see if the sum of 2 different cells equals the value in a third. In basic terms, I want the excel formula for 'If(L6+M6=I6), then turn the cell green'.
Thanks!
Here you go:
cond_format.PNG
Regards,
Thangavel D
Appreciate the help? CLICK *
- Conditional Formatting > New Rule > Use a Formula to Determine which cells to format > Format values where this formula is true
=And($L6+$M6=$I6)
If your original question was resolved, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
Click on the Add Reputation button (located at the lower-left corner of all post) for those who assisted you in solving your issue.
Ah, Thank you for the reply. While I can get it to work on some, it does not work for all for some reason, see pic.
Check.png
In this situation, Sunday + OT = Hours, then turn far right column cell green. It is only working if there are values in both Sunday and OT. If it matters, both Sunday and OT are manually entered while Hours is derived from a formula.
Here's a sanitized version of the worksheet
The conditional formatting formula is working; however, I did notice that the condition does not work when the hours results equals to 4.0 or 5.0.
When I manually changed the enclosed formula to 4.0 or 5.0, there was no issue with the CF.
further investigation required.
Syrkrasi, I haven't looked at the formula or the file but possibly floating point error?
Thanks for the input everyone! I set the WB for 'Set Precision as Displayed' and it appears to be working. Will that cause issues down the road? I'm not dealing with numbers more complex than than Hour differences and Currency.
You're welcome. if that takes care of your initial request, please mark this request as solved.
To answer question #9, yes it could. I would recommend not setting precision as displayed but rather using the ROUND function to round to a set # of decimal places as mentioned in post #8.
Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks