Forum Discussion

NJUys's avatar
NJUys
Copper Contributor
Sep 13, 2019

Excel conditional formatting

I am programming a sheet to conditionally format cells for certain values. I got it right with all the others but struggling with the following. I’ve got a column that  uses Data Falidation to only ...
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Sep 13, 2019

Hi NJUys 

You can use below formula as conditional formatting rule:

 

=OR(AND(A2="M",E2>=94),AND(A2="F",E2>=80))

 

Sample file is also attached for your reference.

Thanks

Tauqeer

  • NJUys's avatar
    NJUys
    Copper Contributor
    Sep 13, 2019
    Thank you, will give it a go.
    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      Sep 13, 2019

      NJUys You are welcome.

Resources