Conditional Formatting based on two conditions

Closed
r71lima Posts 3 Registration date Saturday August 3, 2013 Status Member Last seen August 4, 2013 - Aug 3, 2013 at 04:14 PM
I need to know how to set up a conditional Format for a worksheet that changes every month. I need to have the format highlight an entire row if the results of two conditions are met.

My data example:


Column A:
A
B
D
H
Z
C

Column B:
290034
483643
485673
938473
965746
TOTAL

Column A has my District Letters. I am only interested in having the formula highlight the rows where Column B = TOTAL, however,

If column A = Z, and column B = TOTAL, highlight entire row yellow.

If column A reads (anything) and column B = TOTAL, highlight blue.

Anyadvise?