Conditional formatting cells A and B based on value in C

[Closed]
Report
Posts
2
Registration date
Thursday April 16, 2015
Status
Member
Last seen
April 17, 2015
-
Posts
2
Registration date
Thursday April 16, 2015
Status
Member
Last seen
April 17, 2015
-
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!

1 reply

Posts
14
Registration date
Thursday April 16, 2015
Status
Member
Last seen
April 18, 2015

use VBA (visual basic application)
Posts
2
Registration date
Thursday April 16, 2015
Status
Member
Last seen
April 17, 2015

Can you help me how to write in VBA.