Autofill a range of cells based a a txt value in a separate cell

[c20driver]

I have a speadsheet that has a function to display the day of the week
based on the date.
I want to color in all cells (several rows and columns) under this
header to distinguish weekends.
I will still need to input text into these cells on an occasional
basis.
I am new to Excel, and I am trying to automate what a predecessor took
hours to do mannually.
Thank you for your help in this matter

C20driver

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional format'.

 

[Guest]

Hi c20driver
Frank already pointed you to Conditional Formatting, and this shouldn't be to hard to set up

Just as an aside, you don't need a formula to display the day. If a cell contains a date, you can use a custom number format of "ddd" or "dddd" to display the day of the week

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- c20driver > wrote: ----

I have a speadsheet that has a function to display the day of the wee
based on the date.
I want to color in all cells (several rows and columns) under thi
header to distinguish weekends.
I will still need to input text into these cells on an occasiona
basis.
I am new to Excel, and I am trying to automate what a predecessor too
hours to do mannually.
Thank you for your help in this matte

C20drive