Color cells based on other cells dates

[ethan.wal]

I have a column that has cells in it that I need to automatically highlight red given the following criteria:

--A date in the same row (different column) is before the current date.

For example: If the date in column B is 8/7/19 and today is 8/8/19, I need the cell in that row in column A to highlight red.

Cam anyone please help? - I know how to do this in VBA; however, my supervisor does not want to have to push a button to update the sheet.

[Special-K]

Select the range to highlight, e.g. A1:A1000
Im assuming the columns to check go from column B to column Z, adjust the formula as necessary

Conditional Formatting
New Rule
Use a formula to determine...

=COUNTIF(B1:Z1,"<"&TODAY())>0

Format as red

[Glenn Kennedy]

Use this:

=B2< TODAY()

Supervisors can be a pain!!

[Special-K]

This doesnt make sense

"I need the cell in that row in column A to highlight red."

The cell in that row in column A is... the cell in column A of a particular row, ie if the row is 2 then you're referring to cell A2.

Glen and I have different understandings of the problem.
Im assuming

given a row, e.g. row 2, you want the cell in column A of that row (which would be A2) to turn red if any cell in that row (row 2) is less than today, though you havent specified how far that row extends, only that it starts in B.

Glen's approach is to highlight only cells in column B.

Can you explain what you're after more specifically?

It sounds like you want to highlight cells in column A if there is a date in that row less than today, ie you want to know what rows have dates in them before today's date and you do that by highlighting the appropriate cell in column A of that row. Is that correct?

[ethan.wal]

Glenn's answer provided a solution to the problem I was having.

Thank you