Re: MS excel formula, programming, analysis, presentation and tutorials.
Yes sir na try ko na po yung conditional formatting para mahighlight nya yung cell na zero value.
gusto ko sana sir mag biblink po kasi medyo madami kami materials at medyo matatanda na yung empleyado kaya po need sana ng attractive yung data para mapansin nila agad.
@hephooray, pre hindi naman nid ng vba. bka mas trip mo ung Conditional Formatting na built-in excel feature.
CONDITIONAL FORMATTING
STEP 1
Select mo ung row or (in this case) column.
http://www.symbianize.com/attachment.php?attachmentid=1265704&d=1530233825
STEP 2
Click 'CONDITIONAL FORMATTING' > 'HIGHLIGHT CELL RULES' > 'LESS THAN..'.
merong mag popout na window.
http://www.symbianize.com/attachment.php?attachmentid=1265705&d=1530233825
STEP 3
Set ung value.. dito icocompare ng excel at kung mas mababa dito ang value ng bawat cell na selected
ay i-ha-highlight nya.
http://www.symbianize.com/attachment.php?attachmentid=1265706&d=1530233825
at eto na ung workbook mo.
click here to download
kung hindi eto ung hanap mo. try natin gawan ng paraan.
ung flashing na gusto mo ba ung ng-bi-blink blink blink talaga?
Yes sir na try ko na po yung conditional formatting para mahighlight nya yung cell na zero value.
gusto ko sana sir mag biblink po kasi medyo madami kami materials at medyo matatanda na yung empleyado kaya po need sana ng attractive yung data para mapansin nila agad.