View Single Post
 
Old 11-02-2019, 08:24 PM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Try this for green

Conditional Formatting
  • Highlight applicable range >> =$B$3:$D$18
  • 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(LEN($B3)>0,$D3>$H3)
  • Format… [Number, Font, Border, Fill]
  • OK >> OK

For Red
=AND(LEN($B3)>0,$D3<$H3)

Now apply all of this to F3:H18 by changing all the references
Reply With Quote