Solution for Conditional Format Using Formula

Vikas Verma's picture

Hi Please use below mentioned formulas

=OR($F$39="N/A",$F$39="Yes")
=AND($F$39="No",$F$38<=50000)
=AND($F$39="No",$F$38>50000)

Thanks

Conditional formating.JPG
AttachmentSize
Conditional formating.xlsx10.76 KB