I need to color a cell in Excel 2007 based on a statement like,
if B6=H and C6=g then color A6 Blue
I have no idea what the proper script would be but here is my guess that does not work:
=IF(AND(B6=$H$, C6=$g$),"MAKE A6 Blue")
I am trying to do contitional formatting. Could someone please get me on track?