Conditional Formating of cells based on value in another cell

  • Thread starter Thread starter Vlip
  • Start date Start date
V

Vlip

Is there a way to set conditional formating of a cell or
range of cells based on the value of another cell? I have
a spreadsheet with day of the week across the top. I want
all cells below the day of the week to be shaded if the
value in row 1 of that column is "Sat" or "Sun". Is there
a way to do this? I know I can do it manually, but I'd
like for to be based on conditional formatting since every
month the weedays move.

Thanks!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting with VBA 4
recognizing conditional formatting with VBA 3
conditional format fails when copied 1
conditional formatting? 2
Conditional Format 2
Excel conditional formatting with Weeknum 4
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top