Forum Discussion
Conditional Formatting Based on a Table
Hi, I was wondering if it's possible to do conditional formatting based on the information presented in a table. What I'm specifically looking for is a bit complicated so here's a picture of my s...
Excellent, thanks. I will try those steps. Just to clarify, the $A$1 and $B2 in the generic formula you gave me are relating to cells in the table ie the cell the player name and the cell stating if M/F? Because I may have gotten that wrong
The formula was intended to demonstrate the concept of using the INDEX and MATCH functions for table lookups, but it didn't specifically relate to the cells within your table.
To clarify further, the $AF$3 and $AH4 cell references you mentioned are the ones that should correspond to the cells within your table. The $AF$3 reference is typically used for specifying the lookup value, such as the player's name, while the $AH4 reference is often used for specifying the criteria for matching, like "M" or "F" to represent gender.
Please replace $AF$3 and $AH4 with the actual cell references that contain the desired values for the lookup and matching criteria within your table. The text was created with the help of AI.
To clarify further, the $AF$3 and $AH4 cell references you mentioned are the ones that should correspond to the cells within your table. The $AF$3 reference is typically used for specifying the lookup value, such as the player's name, while the $AH4 reference is often used for specifying the criteria for matching, like "M" or "F" to represent gender.
Please replace $AF$3 and $AH4 with the actual cell references that contain the desired values for the lookup and matching criteria within your table. The text was created with the help of AI.