View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ed[_16_] Ed[_16_] is offline
external usenet poster
 
Posts: 4
Default An Excel question

Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day which is an
OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of the cells
from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")