Home » Forums » Open Source Learning Center » Question and Answer

Solution for Conditional Format Using Formula

Vikas Verma's picture
Submitted by Vikas Verma on 20 March, 2014 - 09:59

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
‹ Conditional Format Using Formula Copy information from range of cells in a series of named sheet to another workbook with the same named sheets ›
»