Conditional formatting only applying to one column

[NHeald]

Hi,

I am currently trying to apply conditional formatting to a number of rows.
What I am trying to achieve is that when Row K shows todays date then then entire column highlights yellow.

Here is the Conditional Formatting I am using:
Formula: =K13=TODAY()
Format: Colour yellow
Applies to: =$A$13:$S$264

When applied, only one cell in each row highlights and its not always the same cell in that row that highlights.

Example:
Row 17 & 18 show todays date but only A17 & A18 are highlighted.
Row 65 shows todays date but only B65 is highlighted.
Row 82 shows todays date but only C82 is highlighted.

The sheet currently has no other conditional formatting.
Any ideas?

 

[wideboydixon]

Put a $ in front of K13:

=$K13=TODAY()

WBD

 

[Joe4]

Welcome to the Board!

When applying Conditional Formatting formulas to multiple-cell ranges, the formulas automatically adjusts as the range adjusts.
So, just like when copying Excel formulas, you need to use Absolute Cell Referencing if you want to lock down a certain column (like K).
So, your formula should be:
=$K13=TODAY()
because we want to lock down column K, but allow the row reference to move.

See: http://www.excel-easy.com/functions/cell-references.html

 

[NHeald]

Brilliant, that worked. Thanks both.