Select A1 to A5 then place this formula into CF

=$A1="Your Text"
format as required. Change Your Text to your criteria

VBA Noob