I have a doubt on conditional formula,
I created staff details with five categories like Personal data/Emp Data/Visa Data/Bank / Leave status. and i created search emp in next sheet
search thro Emp Id and Categories wise,
Prob : Personal data is having 7 column(DATA) and Visa Details are having only 4 columns data, while i select personal data i will get 7 columns details and if i select visa details i will get 7 columns details, 5 to 7 th columns is showing another categories details but acutal visa details are having only 4 columns details for that i am using condtional format to high light as white if the cell value is 0 but it shows only first cell only not in adjusant cell (both cell are formulate cele)
How can i solve
I created staff details with five categories like Personal data/Emp Data/Visa Data/Bank / Leave status. and i created search emp in next sheet
search thro Emp Id and Categories wise,
Prob : Personal data is having 7 column(DATA) and Visa Details are having only 4 columns data, while i select personal data i will get 7 columns details and if i select visa details i will get 7 columns details, 5 to 7 th columns is showing another categories details but acutal visa details are having only 4 columns details for that i am using condtional format to high light as white if the cell value is 0 but it shows only first cell only not in adjusant cell (both cell are formulate cele)
How can i solve