Previous Topic Next Topic

Conditional formatting cells A and B based on value in C

Closed
easyyu Posts 2 Registration date Thursday 16 April 2015 Status Member Last seen 17 April 2015 - 16 Apr 2015 à 23:12
easyyu Posts 2 Registration date Thursday 16 April 2015 Status Member Last seen 17 April 2015 - 17 Apr 2015 à 09:43
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

Réponse 1 / 1
wendellche Posts 14 Registration date Thursday 16 April 2015 Status Member Last seen 18 April 2015
17 Apr 2015 à 04:10
use VBA (visual basic application)
easyyu Posts 2 Registration date Thursday 16 April 2015 Status Member Last seen 17 April 2015
17 Apr 2015 à 09:43
Can you help me how to write in VBA.

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Name Values
brendanconlin -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses