Conditional Formatting Or Macros And VBA Coding

[BowDan]

Have spreadsheet were columns D thru I. Column G is tested to determine what color the letters will in columns D thru I. Certain rows that are totals will be skipped. Should I be using Conditional Formatting or Macros and VBA Coding. ??. I have a total of 11 groups of Columns D thru I.

Thanks for your help

 

[Gasman]

I'd probably try with conditional formatting first.
Why have you made the dates in column B text?

 

[Pat Hartman]

Dates that are text will not compare logically or sort corrctly.