I have attached a file for better explanation.
I would like to Highlight cells associated to Data Validation Selection and UN Highlight them after data Input
I have attached a file for better explanation.
I would like to Highlight cells associated to Data Validation Selection and UN Highlight them after data Input
hi there. select the range you want to apply to (say from K2:P17)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=INDEX($B:$G,MATCH($J3,$A:$A,0),MATCH(K$2,$B$2:$H$2,0))="X"
Format cells and choose the color desired.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Well, place the Cursor in Table 2, Cell J3, make the selection from data validation : say ABC.
At this point I want that cells associated to this selections from table 1 and marked with x (cells K3 and M3) to highlight.
Once the data is inserted, cels dehightlight
Could you Insert the Formula in File attached
After using the formula and conditional formating I got this : please see attached.
I do not want the Logical in cells, just hightlight (which is doing) and de highlight after value input
Hi,
In attach is your file, with benishiryo formula
Spor la treaba Ionele!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks