Need a Conditional formating formula

[vijay.vizzu]

Hi...,


Could you help me to derive the formula in condition Formating. Assume that in A1:L1 it has month names like Jan,Feb,Mar....Dec. From A2:L2 it has some values which are coming from another sheet by Vlookup function. In Cell M2 it has numeric value onbehalf of Month Name like 1 for Jan,2 for Feb... 12 for Dec. In cell N2 it has sum formula along with offset function. If i will enter 4 in cell M2, it will sum from Apr to Dec and result will be displayed in N2. But visually it was confusing to other team members, So i now i want to derive a CF formula for A1:L2, to hide the cell contents based on cell M2 value. like for above example, if i will input 4 (Apr)in M2, then A2 (Jan),B2(Feb),C2(Mar) cell contents should be hide means font to be white. By this way it won't confusing other team members to understood.


So please help me to derive this CF Formula


Thanks

vijay

 

[Faseeh]

Hi vijay.vizzu,


In Cell A2, enter this formula and drag:

=IF(MONTH("1-"&A1&"-2012")>=$M$2,44,""),


PS: I worked out with a fictitious value of 44 against the value fetched by VLOOKUP(), you must replace it by vlookup() formula like:


=IF(MONTH("1-"&A1&"-2012")>=$M$2,VLOOKUP(),"")

,


..so it is working here hope it helps you.


Regards,

Faseeh

 

[vijay.vizzu]

Thank you Faseeh, It meets my target.