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

Conditional Format Using Formula

Submitted by kashifulhaq on 19 February, 2014 - 09:44

I wish to have the following conditional formatting, but I am not able to correctly put the formula. Can anyone help me with this?

Cell F39:
Color code "Green" if F39 contains text "N/A" or "Yes"
Color code "Amber" if F39 contains text "No" & F38>=1<=50000
Color code "Red" if F39 contains text "No" & F38>50000

Cell F38:
Color code "Green" if F39 contains text "N/A" or "Yes"
Color code "Amber" if F39 contains text "No" & F38>=1<=50000
Color code "Red" if F39 contains text "No" & F38>50000

Cell F37:
Color code "Green" if F39 contains text "N/A" or "Yes"
Color code "Amber" if F39 contains text "No" & F38>=1<=50000
Color code "Red" if F39 contains text "No" & F38>50000

‹ Solution for Need to copy a certain sheet to the amount of the value on InputBox Solution for Conditional Format Using Formula ›
»
Vikas Verma's picture

Try this

Submitted by Vikas Verma on 20 March, 2014 - 10:01.

Hi Dear,

Please visit: http://excelexperts.com/solution-conditional-format-using-formula

thanks

»