infiniti7181
asked on
Excel Query - Filter and Conditional Formatting
Team,
i would like your clarification for the following . Template i have attached for your reference
Clarification 1 :
Is it possible , that i can have the whole row colored, if i select particular department such as IT
ie, if i select D3 as IT , then the row A2:D3 will be colored .
Clarification 2 :
If i color individually TAG# cells, can i filter cells only by color . Objective is to followup on the cells at the later stage .
Highly appreciate your support
Regards,
Sid
template.xlsx
i would like your clarification for the following . Template i have attached for your reference
Clarification 1 :
Is it possible , that i can have the whole row colored, if i select particular department such as IT
ie, if i select D3 as IT , then the row A2:D3 will be colored .
Clarification 2 :
If i color individually TAG# cells, can i filter cells only by color . Objective is to followup on the cells at the later stage .
Highly appreciate your support
Regards,
Sid
template.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.