Excel formula help

P

Pags10

I work for a temporary housing company and would like to create a calendar
where all i have to do is put the clients name and dates they are staying in
a "key" and it will automatically block out that range of date an a calendar
(and preferrable tent the cell red meaning occupied). Does anyone have any
advice on what formula would get this accomplished?

Thank you in advance!!
 
A

Ando

Suggest vlookup formula in conditional formatting.
Requires the date to be in the cell of the calendar date.
vlookup on cell date to see if it is in the key.
For exmaple if the date within the key is in C1 to C8 then the vlookup
within conditional formatting in cell A1 is:
=VLOOKUP(A1,$C$1:$C$8,1,FALSE)

Ando
Click yes if it helped
 

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 Formatting - Cannot get it to work, please help 1
Formula Suggestions/Help 1
Logic Formula using colors in the formula? 2
formula to enter data into a blank cell 2
Need urgent help with Excel formula 1
activate formula when adjacent cell populated 4
Help Needed 2
Problem using IF statement with dates as part of the formula 4

Top