Excel Conditional formatting that highlights values depending on two rules

i have four columns that are simplified and look like this

item quantity item quantity

102 --- 1 --- 102 --(-3)

103 --- 1 --- 104 --(-1)

105 --- 1 --- 105-- (-1)

i want excel to highlight 104 in the third column because it does not exist in the first column, and i also want excel to highlight 102 in the third column because even though it exists in the first column, the absolute value of the number corresponding to it is higher than the corresponding value of 102 in the first column

Replay

Category: microsoft excel Time: 2016-07-31 Views: 2

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.201 (s). 12 q(s)