Conditional Formatting in table generated using TABLE function using formulas

[savvynavvy]

Hi All

Just joined and perhaps this has been covered here before - but here goes:

Using a 2 variable table using the TABLE function I am trying to highlight a single cell in colour where 2 conditions have been met ...... I attach a sheet that illustrates what my issue is ....I think the fix is simple - but just cant see it ....too tired I guess...

Many Thanks in Advance

[CAABYYC]

1. manually select C16:J25
2. "conditional formating"->"new rule"->"use a formula....."
=AND(C16=$G$7,$B16=$F$6,C$15=$F$5)
3, select color, save to exit.

[savvynavvy]

Perfect - Many Thanks!! SOLVED

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.