Recent content by vpxlquest

just brilliant. i never thought of doing this the law of opposites. thanks again Hui for solving this one.

Thanks for your reply but my question was if the user types in anything other than yes or no it should be formatted. With yoru answer when the user types in ABCD CF will be applied. I worked around the problem by limiting the user to a list box with the only 2 options yes or no to pick from...

Thanks for your reply but my question was if the user types in anything other than yes or no it should be formatted. With yoru answer when the user types in ABCD CF will be applied. I worked around the problem by limiting the user to a list box with the only 2 options yes or no to pick from...

Hello All, I am using Excel 2007. I know how to conditionally format a cell if it is blank Or say cell value = “yes” or cell Value=”no” color the cell. How to cf if the entered text is anything other than yes or no than turn red. Any pointers will be appreciated. Thanks again for...

Hello All, I have a task were i need to format cells based on conditions. The spread sheet is available here https://docs.google.com/spreadsheet/pub?key=0AisY7zbvSsm4dGlvZWNDcDBzdWlPWmZWbkR3LTdUcXc&output=html On the left hand side i have details of employee training schedule with dates...

I will work on this logic to get my results thanks once again. appreciate your time.

Thanks for taking the time to create this xl sheet. it is very useful and i can customize it for my requirements. I currently am using countif to count the number of employees signed up for a course. since the dates are listed as month/day/year i used some helper columns to derive the year(date)...

My dates are mm/dd/yy. Course 1 validity is for 3 years , course 2 is for 2 years and course 3 is for 4 years. Also i first need to calculate individual participant validity if their course completion has expired or they are still valid till another year. each course has a different course fee...

I work with excel 2007. I have an excel spreadsheet which requires some calculations. Calculating the course fee that the company will incur this year to run the refresher program. The dates are when the employees last did the course. Eg. participants course 1 course 2 course 3...

I use excel 2007 I have selected use a formula to determine which cells to format Can I use the formula for a range of cells like this =AND($C12:$C200 <> "",$D12:$D200 <>"") format some color. Thanks again.

Hello All, I would require some conditional formatting insight and help here. I have values in Col A and some hours in Col B Col A | Col B Task 1 | 23 Task 2| 44 How to apply conditional formatting to the entire col –A such that it should fill up with a color if the col B is empty ( col B...

thanks that worked like a charm

I have a match function that selects the code and returns the position =MATCH("G222",C1:C70,0) How to change the formula to say if match found then in cell S20= completed or if not found then S20=incomplete when a match is not found it gives #NA how to work around that. appreciate all...

Understanding these codes. =SUMPRODUCT(((LEFT($C$12:$C$1000,1)="A")*$D$12:$D$1000)+(($C$12:$C$1000="")*(LEFT($C$11:$C$999,1)="A")*$D$12:$D$1000)) Xld code why do we have 1 cell less (999) than the set range of 1000 Hui code =SUMPRODUCT(--(LEFT($C$12:$C$1000,1)="b"),($D$12:$D$1000)) Both the...

ok xld solution =SUMPRODUCT(((LEFT($A$12:$A$200,1)="A")*$B$12:$B$200)+(($A$12:$A$200="")*(LEFT($A$11:$A$199,1)="A")*$B$12:$B$200)) eliminated the problem and i can insert a new task inbetween 2 tasks. I really thank Hui and xld for sticking with me through all my rambling till i found out...