kashifulhaq's blog
Conditional Formatting Using Formula
Submitted by kashifulhaq on 19 February, 2014 - 09:40I 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"
»
- 2 comments
- Read more
- 3923 reads
Recent comments
5 years 1 week ago
5 years 39 weeks ago
5 years 51 weeks ago
6 years 1 week ago
6 years 2 weeks ago
6 years 8 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago