!format1format2format3TP- see workbook task "ConditionalFormat"*&Enter some number:@<Conditional Formatting Sample- enter positive number or negative number or text to cell b6 to change format.*Please enter number! $ConditionalFormatnc = ActiveCell() if IsNumber(c) if c > 0 FormatPainter(e1) else FormatPainter(e2) end else FormatPainter(e3) Set(ActiveCell(), "Please enter number!") endSheet1 O7GArialK F@PGOGArialK F@PGOGArialK F@PGOGArialK F@PGOGArialK F@PGOGArialK F@PGO7 G"ArialK F@PGO7 G"ArialK F@PGO7G"ArialK F@PGO7GArialK F@PG  - - K - K  K - K %-%d.M.yyd-MMM-yyd-MMMMMM-yyh:mm tt H:mmh:mm:ss ttH:mm:ssd.M.yyH:mm >       #   ##   ##   # d&?'?(?)?*,d#  D E # # #