Conditional Formatting in ExcelClosed

Question

Hello,

I am trying to incorporate a little checker into my spreadsheet.

I basically have a table of numbers and I would like them to be coloured green if they match any of the numbers in the row of B23 - G23.

This would be easy if I could have more than 3 rules but this isn't the case.

I need a formula that will do this. I have been trying many different OR statements but keep getting errors or the whole sheet gets coloured in.

Any help would be greatly appreciated.

Trowa · Answer

Hi ndev2k,

I would create a column where I would put nested IF formula's to determine if the numbers match the numbers in row B23:G23.
Then use the result from the nested IF's as a condition for your conditional formatting.

Hope this will make sense.

Best regards,
Trowa

Trowa · Answer

Rearrange the table of contents into a single column for my solution to work.

I know it's not ideal, but I don't know how to write a VB code like "for each cell in range ..."

So if you want to use my solution with nested IF's but can't get it to work, show me your sheet. Post your link or use https://authentification.site to upload your file (remember not to use any personal information).

If you would like to use a VB code, I can't help you any further.

Let me know what it will be?

Best regards,
Trowa

Conditional Formatting in Excel

2 responses

Similar discussions

Subscribe To Our Newsletter!