Hi,
i need to solve a two problem on my excel sheet.
1. i need to highlight the color (red) based on cell value if shows in column " F (overlap column) " and if value is not show then it should turn white color in ' F (overlap column)' column is depends the checkbox what i select in column in "AS 8:AS 11".
2. In sheet " yearly planner" and sheet " yearly planner (1) " the data which i select and entering of column in " A to E " whenever the both sheet data should automatically transfer to sheet " All user list " in column " A to E " because of this sheet all the employees leave can be tracker.
please solve this two problem i tried lot but its not working....
ref the attachment.
Reply With Quote