Previous Topic Next Topic

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!

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

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses