Can any one help me out to write me a code which I can copy on the vbeditor for excel
I want excel to check the value of the cell 1st Check if a cell had to start.. For this say A1:A35 has the values in true n false form If value is false then make the colour white with white text else check the next condition..(actually it should check true n if should continue..) 2nd Check if completed For this check value in B1:B35 if true or false If true then yellow else next condition 3rd For values stored on C1:C35 Each cell will be linked to their respective cells between C1:C35 So each cell is having a value Check if the cell has negative value the Red else Lavender Now one more check in the first conditionÂ… If false check if this had to start for this , I have a fixed cell as data date.. say$Z$1 Check the start date in a cell in D column for this cell if this date is <= the Data Date then cell has to be "Light turquoise" with font of same color else white n white font These will b in the conditional formatting r even if in the form of a macro or a module What ever.. One more thing Is there any thing with which I can make excel select dates excluding FridaysÂ… I want something on calendar n not the Networkdays command.. How do I make excel use a calendar I specify?? can v do something abt this??? I have made very lengthy formulaes for this which is very confusing to othersÂ… ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
