|OK, here's the disconnect:|
You said: "I already have it set up so that Row 1 is the current date i.e. today would read Thursday, October 25, 2012."
I doubt that every cell in Row 1 contains today's date.
Do you mean that A1 has today's date? e.g. in A1 you have =TODAY()?
If that's the case, then try this:
Select all of the columns that contain your dates and use this Conditional Formatting Rule:
Choose a formatting color.
This will highlight any cell in the columns selected if it contains an X (or x) AND the cell in Row 2 of that Column contains today's date.
Note that this rule isn't using the date in A1 at all. It is only checking the dates in Row 2 to see if they match the value that would be returned by the TODAY() function. There's no need to compare the dates in Row 2 to A1 if it can be done within the Rule itself.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.