Conditional formatting cells A and B based on value in C

Closed

easyyu Posts 2 Registration date Thursday April 16, 2015 Status Member Last seen April 17, 2015 - Apr 16, 2015 at 11:12 PM
easyyu Posts 2 Registration date Thursday April 16, 2015 Status Member Last seen April 17, 2015 - Apr 17, 2015 at 09:43 AM

Hello,
As you can see from picture:

I want to fill with red colour cells A and B if value from C is equal with value from A.
I want to do this without any sorting of rows.
The next picture show what I mean. The value from C isn't matter to fill with colour because I will delete whole C row later.

Example file: https://authentification.site/QMBZp/Example.xlsx
Thank you very much for help!

Conditional formatting cells A and B based on value in C
Excel macro to create new sheet based on value in cells - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Highlight cell if another cell contains any text ✓ - Excel Forum
Conditional formatting if another cell contains - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum

1 response

Answer 1 / 1

wendellche Posts 14 Registration date Thursday April 16, 2015 Status Member Last seen April 18, 2015
Apr 17, 2015 at 04:10 AM

use VBA (visual basic application)

easyyu Posts 2 Registration date Thursday April 16, 2015 Status Member Last seen April 17, 2015
Apr 17, 2015 at 09:43 AM

Can you help me how to write in VBA.

Similar discussions

How to use conditional format based on text?

help me to add particular cells

one cell will turn green when the two other cells match

How do I change a base location on Instagram?

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!