Originally posted by: franguinho
try www.mrexcel.com
Originally posted by: HomeBrewerDude
=($A$1="NO")
select "formula is" under Condition 1 and use the above formula, set the text format to what ever wnat.
you can copy formating settings by copy/paste special/formatting