Hi Divelonger,
In your Form sheet, change cell D3 which is called RowIndex to 24. this is the number that matches M24 and thus the result will be 75.
Done
Hi SirJB7
The formula works very well for one column. My qestion is what if I had a number of columns each with a different heading. What formula may be used?
Regards!
Hi Divelonger,
There is a cell shift by +1 in your formulas in the data sheet.
for example the formula in O1 contains [Data Master.xlsx]OFFICE'!M2="Y";"HAVE";"HAVE NOT") Notice the M2. i think it should be M1 and all the cells have the same error. Please amend it and see if it works.
Hi all,
What formula to use for the following:
I want to do CF for a number of columns that contain different values.
The condition is if the cell contains 50% of the header value, then the cell is conditionally formatted red for example.
Regards!
Hi all,
I have the following workbook.
http://www.2shared.com/document/OAwwJwTO/2010-calendar_-_Calendar_highl.html
It is a calendar. What I want to do is highlighting the current date in the Outline worksheet.
Please give it a try.
Hi SirJB7,
You see for example Cell B5 in the Outline worksheet contains the month of January and it is actuall a merged cell (B5 to H5) . I removed the merging of these cells so that I have individual cells B5 C5 D5 and so on. I did the same for the rest of the months .
Please try this and...
Hi SirJB7,
Thank you very much for the good try. Yes, it is weired action though it says it is OK when I do formula evaluation for AC11.
I tried something else. I removed the cell merge for the month names.
Please try it and see what happens.
This issue turns to be interesting and...
Thanks a lot SirJB7,
Can I do the same to the calendar in the outline worksheet? What formula would I use?
NB the file worked well on excel 2010 not 2007.
Regards
Gracias SirJB7,
I downloaded the file. It does NOT contain any CF and the today's cel is not highlighted. You may have uploaded an unamended file. Would you pls send it again?
Thanx
Hi SirJB7,
As for the separators in the function, Excel 2007 that I use does not accept ( , ) as a separator and gives me an error message so that i had to change it to ( ; ).
Yet, the program still does not accept the refernce to Outline! for CF
Any solutions please?
Thanx
Hi SirJB7,
I liked your amendments.
The holidays in my country are Fri. and Sat. so they are highlighted grey.
Next, when I put the rule =DATE(Outline!$D$3;ROW()-3;C4)=TODAY() as a new rule in CF, I got a message saying I cannot use a reference to another worksheet for CF in this case...
Hi SirJB7
Thank you for your interest and reply. YES, the formula works well in the pictorial calendar, but this is not the calendar that I depend on in my work. I have uploaded my calendar for you to try to set the highlighting formula. I tried but failed...
@Luke M,
Please check this page. Can the code be shortened?
http://www.teachexcel.com/free-excel-macros/m-145,create-calendar-12-month-excel-macro-free.html
Thanks Luke,
Actually I used the formula A2=today() , but as i said, all the calendar was formatted. The problem is that the cells contain just numbers and not dates. I mean they contain the numbers from 1 to 31 for the month of January and so on. They do not contain dates.
Hi all,
In an excel calendar that depends on formulas to calculate dates, e.g. http://chandoo.org/wp/2012/01/02/picture-calendar-template/
I need to highlight the cell that shows the current date. I tried conditional formatting with a formula =TODAY() and chose to fill the cell red, the...