I have a spreadsheet where row 1 is dates, spanning 3 columns each. Columns A-C are Product Name, Order #, and Case Count, respectively. D-F (repeating indefinitely) are Sold, On Hand, and Order, respectively. I want a dynamic formula applied to the whole sheet that checks row 1 for today's date and the order column for quantities greater than 0. Currently, I have =AND(A$1=TODAY(),C>0) and it works as expected. The problem is, it's formatting cells in the wrong column (relative A as opposed to relative C). Is there a way to alter this so formats relative column C?
Solved by T. Q. in 13 mins