Formatting Cells

[Johneboca]

I am new to Excel

[Johneboca]

Example:-

I have 6 cells, B4 to G4 which hold different numbers
I Have a grid B6 by G27

When the grid B6 by G27 is filled with numbers and any = the cells B4 to G4 I need the cell or cells in B4 to G4 too fill with Red.

How do I do it.

[Glenn Kennedy]

You did not tell us if any cells in both areas could contain blanks; so I have assumed that they CAN.

Use this as the conditional formatting formula:

=SUM(INDEX(($B$6:$G$27=B$4)*($B$6:$G$27<>"")*ROW($B$6:$G$27),))>0

and apply it to B4:G4.

next time, please read the yellow banner (top) and attach a sample sheet, with expected answers... that helps remove the element of guessing.

[Johneboca]

Thank you Glenn.
As I am new to Excel I thought I was entering my problem as I see it, simple as it is. As I progress, entering if there were Blanks, and an example worksheet I will do.

I am now going to try out your solution on my worksheet, as your example clearly shows it works.

Regards Johneboca

[JohnTopley]

Or

=COUNTIFS($B$6:$G$27,B$4)

Apply to B4:G4

[Johneboca]

Success Glenn

Many Many Thanks

Johneboca

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.