This is pick them file



GET FILE HERE




ty
moot70

Attached Images

	MY PICKS.jpg (122.4 KB, 21 views)
	PICK THEM WITH COLOR.jpg (269.0 KB, 20 views)

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

I need one formula tell which way green or red one want B:E or F:H to be highlighted I do not know which team will win until I put score. Than look at column B or F to see have * than look at column D & H to tell be green or red.

it is kinda like check mark or X i want colorize will be easy see which one I got right and wrong

I want like picture my first post


TY

crossposted at MrExcel and Excel Forum.

anybody out here help?

It's possible we can help, but would be nice if you posted the links to your cross posts!

upadate File take look at it and see I need help with it
GET UPDATED FILE

TY Moot70