EXCEL question

[Les Bogert]

How do I use a formula in EXCEL Conditional Formating to set a color in Cell
H1 based on the text in cell B1 and the number in cell H1?

If B1 = "TEXT1" and H1>"NUMBER1", then H1 RED
or
IF B1 ="TEXT2" and H1>"NUMBER2", then H2 RED

If B1 = anything else, and H1 = anything else H1 color default white.

 

[Kevin B]

In cell H1, click FORMATTING in the menu and select CONDITIONAL FORMATTING.

In the Condition1 drop-down change CELL VALUE IS to FORMULA IS and in the
textbox to the right of the drop down enter the following formula:

=AND(B1="TEXT1",H1="NUMBER1")

Click the FORMAT command button, click the PATTERNS tab, click the red color
box and click OK 2 times to exit.

MOve to cell H2 and repeat the same process, but change the formula in cell
H2 to the following:

=AND(B1="TEXT2",H1="NUMBER2")

Click the FORMAT command button, click the PATTERNS tab, click the red color
box and click OK 2 times to exit.