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

C

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
 
M

Mark Graesser

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
[email protected]
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
 
Top