Conditional Formatting Macro when there is two interdependent Criteria

[GERALDRAHMAN]

Hi All

I need a macro that will color cells based on the name of the Branch and the daily turnover. If Branch C makes more than 4,000 then Blue, If Branch B makes more than 6,000 then Blue, if Branch A makes more than 10,000 then blue. Other one: If Branch C makes less than 1,000 then Red, If Branch B less than 2,000 Red, If Branch A less than 5,000 Red.

Branch A		Branch B		Branch C
8,000.00		8,000.00		8,000.00
4,000.00		4,000.00		4,000.00
12,000.00		12,000.00		12,000.00
6,000.00		6,000.00		6,000.00
11,000.00		11,000.00		11,000.00
9,500.00		9,500.00		9,500.00

<colgroup><col width="64" style="width:48pt"> <col width="64" style="width:48pt"> <col width="64" style="width:48pt"> <col width="64" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

Have tried using the filter, but a Macro would be much better suited and time saving. Thank in advance.

 

[s hal]

Have you tried using conditional formats and formulas? Not sure why this needs to be a macro at all...?

 

[GERALDRAHMAN]

I am reviewing data over a 3 year period, [to identify any trends] so there are many worksheets involved, to physically enter the formulae in each worksheet would take so much time when it can be done using a macro.

 

[GERALDRAHMAN]

Here is an example of the type of macro I need but it doesn't meet the 2 interdependent criteria

Sub TRIAL()Dim tt As Worksheet, rCel As Range, sCel As Range


For Each tt In ThisWorkbook.Sheets
    tt.Select
    For Each rCel In Range("L15")
        If rCel > 1000 Then rCel.Interior.Color = 255
    Next
Next


End Sub