PDA

View Full Version : Based on cell value highlight cell and transfer data from one to another sheet



sathishsusa
02-28-2017, 03:26 PM
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.