Avatar of cfhasan1
cfhasan1
Flag for United States of America

asked on 

Conditional fromatting formula

My current formula:  =IF(AND($H4<>"",$I4<>""),J4=MEDIAN(J4,$H4,$I4)) does work;  However, I need to and another condition.  If need to if G4 = inspection turn green, if G4 = training turn red
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
cfhasan1

8/22/2022 - Mon