How to Highlight the Entire Column using conditional Formatting

**wrangler** · 03-17-2011, 11:28 AM

How to Highlight the Entire Column Based on Specific date, Thursday & Friday to be exact, using conditional Formatting.

**NBVC** · 03-17-2011, 11:33 AM

Select the column and go to Format|Conditional formatting

Formula Is:

=OR(WEEKDAY(A1)=5,WEEKDAY(A1)=6)

where A1 is topmost cell in selection

Click Format and choose from the Pattern tab.

**zbor** · 03-17-2011, 11:34 AM

Select whole row (or as many cell as you like).

Then in CF use a formula to determine which cells to format

In Format values where this formula si true write desired criteria referencing to one cell:

For example, if your date is in G column use:

=ABS(8-(WEEKDAY(G1, 2)+WEEKDAY(G1, 3)))=1

**wrangler** · 03-18-2011, 09:37 AM

Thanks guys ... But How to Highlight the Entire Column?

**NBVC** · 03-18-2011, 09:40 AM

So are these dates in one row, and you want to hightlight th column based on the criteria being met in that row?

is so, then you need to "freeze" the row number in the formulas.

e.g.

=OR(WEEKDAY(A$1)=5,WEEKDAY(A$1)=6)

where Row 1 contains the dates to check, starting at column A.

This will highlight the whole column (based on you having preselected the columns when applying the conditional formatting).