Excel rango de valores

Question

He realizado una tabla de excel en la cual necesito que si el sujeto es Masculino se utilicen una serie de fórmulas y si el sujeto es femenino se utilicen otras.

Cómo puedo hacer para que me den diferentes formatos las celdas dependiendo de si es masculino o femenino. Quiero decir: Si es masculino, los resultados de esa celda deben ser: <20 (verde), 21-25 (amarillo), >25 Rojo
Pero en esa misma celda quiero que si es mujer los resultados sean: <25 (verde), 26-30 (amarillo), >30 Rojo

Answer 1

QnA currently supports the products listed here (more to be added) Better to reach out to subject matter experts in dedicated forums over here.

https://answers.microsoft.com/es-es/msoffice/forum/msoffice_excel

(please don't forget to mark helpful replies as answer)

--------------------------

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

I tried to create it.
I hope it gives you a hint.
It used Sheet3! , to classify ABC, add color,
It did same color cells and texts D column on the colord!

Download and save it locally to see it in action.
Enter in B11 to C45.
You can change the values ​​of F2 to F3.
In that case, the value of column B must be the changed value of F2 to F3.
Judgment color appears in column D.

https://1drv.ms/x/s!At950JyIeN6wgehjg0LKv9n5tDshHg?e=tQ16x8