Formato condicional

%3CLINGO-SUB%20id%3D%22lingo-sub-2247327%22%20slang%3D%22es-ES%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2247327%22%20slang%3D%22es-ES%22%3EHello!%20I%20want%20to%20put%20conditional%20formatting%20so%20that%20in%20the%20face%20of%20a%20change%20in%20salary%2C%20select%20with%20color%20in%20the%20cell%20that%20salary%20that%20has%20suffered%20the%20greatest%20variation%2C%20as%20well%20as%20the%20position.%20Can%20it%20be%20done%3F%20What%20formula%20do%20I%20have%20to%20put%20in%20the%20formatting%20rule%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2247327%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hola! Quiero poner formato condicional para que ante una variación del salario, seleccione con color en la celda aquel salario que ha sufrido mayor variación, así como el puesto. ¿Se puede hacer? ¿Que fórmula tengo que poner en la regla de formato?
1 Reply

Hi @Patriciaruig 

Suppose you want to highlight the row where salary is increased by more than 20% and the position of the employee is also changed. You may use below logic in conditional formatting rule:

=AND($D2>20%,$E2<>$F2)

You may adjust the rule as per your requirements.

tauqeeracma_0-1617327661988.png

You may refer the attached file for more clarity.

 

Thanks