I need a macro that will filter on a field and highlight cells that have a value greater that 0 for specific cells. I have attached an example. In the example the macro need to do the following:
1.Filter on the field titled "Paid", where the field "Paid" = Yes.
2.Highlight the cells in blue where the values in the cells are greater than 0 for the columns with the titles (G1,G3,G5,G7)