Conditional Formatting - fill color based on another cell color or font format?

[lichldo]

Hello, I am trying to make a table to input a set of daily data, so I have my dates (using a formula) as the top row, and have applied conditional formatting so that the WEEKEND dates are in blue and have strikethrough text. I would like to carry that formatting down to all the rows beneath each weekend date so that it's clear data won't be needed on those dates. Is there a way to automatically carry it down, or even add an "N/A" in the columns below the weekend dates? I would need it to go down to row 29, and then I have my next month table starting.

 

[Joe4]

If you already have a Conditional Formatting formula that does this for row 1, it is easy to extend it for the other rows.
Just select all the rows you want to apply it to, and lock the row reference in your Conditional Formatting formula with a "$", i,e, A$1

Regarding the "N/A", Conditional Formatting can only affect formatting, not cell values.
You would need to do that with a formula, VBA, or simply manually enter it in for the first row of data (row 2), and copy down as far as you need.

 

[lichldo]

If you already have a Conditional Formatting formula that does this for row 1, it is easy to extend it for the other rows.
Just select all the rows you want to apply it to, and lock the row reference in your Conditional Formatting formula with a "$", i,e, A$1

Regarding the "N/A", Conditional Formatting can only affect formatting, not cell values.
You would need to do that with a formula, VBA, or simply manually enter it in for the first row of data (row 2), and copy down as far as you need.

My current conditional formatting formula is =WEEKDAY(B1,2)>5 and applies to range $B$1:$AF$1
My first date starts in B1

So how would I extend down to row 29?

 

[Joe4]

Clear you current Conditional Formatting rules.
Then select the range B1:AF29.
Then enter the Conditional Formatting formula:
=WEEKDAY(B$1,2)>5
(this will allow the columns to float, but locks in row 1, so that EVERY cell in your selected range will look at the date in row 1)
And then choose your formatting options.

If you aren't already familiar with Absolute, Relative, and Mixed cell references, I highly recommend reading this article here: Absolute, Relative, and Mixed Cell References in Excel