If you're going to post a question with an attachment, probably would be a good idea if the attachment was in the format of the question. Excel that is, not word...
See how this goes...
Conditional Formatting- Highlight applicable range >> AH2:AK39
- Home Tab >> Styles >> Conditional Formatting >> New Rule
- Select a Rule Type: Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =AND($AK2<>"",$AK2<=$AK$40)
- Format… [Number, Font, Border, Fill]
- OK >> OK
11-01-2018, 03:42 PM
Similar Threads
Conditional Formatting - Duplicates - Apply to specified range
Windows Vista 
Office 2007
Threaded Mode