Dstor If Dr Aksl O Tghr Rng

Ba slam k jdol do ston dr aksl darm kh ston aol k combo box ast kh 4 mkdar mdr karshnas mseol karshnas o karbr mgrd. Mntthr soealat shma dr sat. Dr aksl 2003 o pan tr fkt mtoand 30 paramtr dr frmol khod dashth bashd o tol frmol shma nbad az 1024 karaktr bshtr bashd.
دستور if در اکسل و تغییر رنگ

Hala ro gznh ok klk knd.

Dstor if dr aksl o tghr rng. Tghr rng slol dr dstor if anjmn aksl frsaran khosh aamdd mhman ltfa bra orod anja o a bra thbt nam anja ra klk knd. Gthashtn shrt dr aksl ba tabaa if bsar pr karbrd ast o atfaka akthr karbran tazh kar aksl ba aan km mshkl darnd. Dr an mtlb asol astfadh az frmt dh shrt dr aksl conditional formatting ra araeh khoahm krd. Aamozsh aksl pshrfth tghr rng slol faaal ba astfadh az vba dr aksl aalrda aaabd 41 hzar bazdd 1 sal psh.

Amdoar hstm az an aamozsh nz nhat astfadh ra bbrd o aan ra bh kar grd. Astfadh az tabaa if bh hmrah toabaa and o or dr. Hmontor kh mbnd slol ha kh mkdar aonha kmtr az 12 hst bh sort khodkar bh rng krmz tghr. Hala dr ksmt smt chp aad 12 ro bnosd o dr ksmt smt rast hm light red fill with dark red text ro antkhab knd o aok knd.

Mkhoahm rng ston dom br asas mkdar kh ston aol grft tghr knd. Hmchnn shma nhoh ajad koann frmt dh mtfaot nhoh astfadh az conditional formatting br asas slol ha dgr o nhoh tghr o kp krdn koann khod ra. Dr an mkalh aamozsh dr bkhsh aamozsh aksl az sat fraz saft bh aamozsh tabaa shrt if o karbrd aan dr makrosaft aksl prdakhtm. Bh nthr mn mshkl asl aanha dr 2 chz ast aol aankh khod tabaa ra dkk drk nkrdh and o dom aankh tmrn kaf nm knnd ta.

Hala ma mkhoam ba astfadh az tabaa if aksl frmol ro dr ston odaat bnosm kh dr sort kh mojod anbar hr ktaah bzrgtr a msao drkhoast mshtr bod odaat kala kabl arsal o dr sort kh mojod anbar kmtr az drkhoast mshtr bod.