Conditional Fomatting with range values
Closed
vikassova
Posts
1
Registration date
Wednesday December 4, 2013
Status
Member
Last seen
December 5, 2013
-
Dec 5, 2013 at 12:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 5, 2013 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 5, 2013 at 11:02 AM
Related:
- Conditional Fomatting with range values
- Apple airtag range - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Copy range data in a column to new column. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 5, 2013 at 11:02 AM
Dec 5, 2013 at 11:02 AM
Hi Vikassova,
I'm guessing your first example is a typo and should be between 2 and 4.9 or else it doesn't make much sense.
Wouldn't it be better if users can't input a 'wrong' value?
Top menu > Data > Validate...
Choose the last option from the first dropdown list and enter this formula:
=AND(C1>A1,C1<B1)
Otherwise use this formula in CF:
=AND(C1<=A1,C1>=B1)
Best regards,
Trowa
I'm guessing your first example is a typo and should be between 2 and 4.9 or else it doesn't make much sense.
Wouldn't it be better if users can't input a 'wrong' value?
Top menu > Data > Validate...
Choose the last option from the first dropdown list and enter this formula:
=AND(C1>A1,C1<B1)
Otherwise use this formula in CF:
=AND(C1<=A1,C1>=B1)
Best regards,
Trowa
