Hi all
Can someone help me with conditional formatting:
i have three columns: 1. main value, 2. value #1, 3. value #2
column 1. has main values, columns 2. and 3. can have values same as column 1. but if column 2. has value then column 3. shall not have it and vice versa.
i would like to use conditional formatting on 2. and 3. column that would color them if values in 2. and 3. differ from 1. column but that it wouldn't color them if there's value in the other column of those two (2. and 3.)
for example:
1.main value 2.value #1 3.value#2
1..................1.............................-> both 2. and 3. should be without color (because there is value in 2. and its same as main value)
2...................................2............-> both 2. and 3. should be without color (because there is value in 3. and its same as main value)
3...................1............................-> 2. should be colored and 3. should be without color (because there is value in 2. and it differ from as main value)
4...................................1............-> 2. should be without color and 3. should be colored (because there is value in 3. and it differ from as main value)
Bookmarks