Thread: [Solved] Conditional Formatting Individual Rows in a range
View Single Post
 
Old 11-01-2018, 03:42 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
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
Reply With Quote