ExcelBanter - EXCEL question

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.
--
Kevin Backmann

"Les Bogert" wrote:

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.
--
Les Bogert