I need help with conditional formatting

jeffreybrown · #2 11-02-2019, 08:24 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting	Joanne	Excel	8	01-28-2019 08:30 AM
Conditional Formatting	chrisoconn	Excel	0	07-05-2017 02:10 AM
Conditional Formatting	solberg2004	Excel	2	01-27-2017 10:07 AM
Help with if and conditional formatting	piper7971	Excel	11	06-10-2015 12:07 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM