Excel rango de valores


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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,033 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Dave Patrick 352.4K Reputation points MVP

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


    (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.

    0 comments No comments

  2. Nobuko IT 236 Reputation points

    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.


    0 comments No comments