Index Match Conditional Format

[chefdt]

Trying to figure out how to highlight a cell in an array, based on the results of an INDEX MATCH function.

=IFERROR(INDEX($C$5:$O$23,MATCH(E25,$B$5:$B$23,1),MATCH(E27,$C$4:$O$4,1)),0)

I would like the resulting cell highlighted.

Can't for the life of me figure it out.


Dale

 

[Eric W]

Select the range C5:O23. Click Conditional Formatting > New Rule > Use a formula > and enter:

=AND($B5=$E$25,C$4=$E$27)

Click Format... and choose your fill color.

 

[chefdt]

Select the range C5:O23. Click Conditional Formatting > New Rule > Use a formula > and enter:

=AND($B5=$E$25,C$4=$E$27)

Click Format... and choose your fill color.

LOL....Literally worked all day on this! I owe you big time.

DT