The best way to set conditional format function in Excel to produce the comparison of constructive a

Lots of times, in an effort to view the data more intuitively, we'll use different colors in Excel to distinguish the comparison in the constructive and unfavorable values ​​of the data. Just after website from the Excel version, the function of conditional formatting has also been continuously enhanced. It can be now attainable to clearly distinguish the good and unfavorable values ​​in the cell through a coordinate axis, to ensure that the visualization of information comparison is additional visual.

Here is usually a usage of an Excel conditional format rule. data recovery software is as follows:

Renderings

Operation steps of Excel conditional format rule setting:

1. https://zenwriting.net/driveshock19/u-disk-file-is-lost-dont-worry-use-this-free-system-to-retrieve-youll where you would like to set the information bar, click [Conditional Format] inside the 'Style' selection group on the [Start] tab, choose 'Data Bar' to find out the gradient fill and solid fill, you could select your own personal requires Style.

Stripe style selection

2. Right after the data strip setting is completed, open the 'Management Planning' dialog box, choose the conditional format rule to become set, and pick the edit rule.

hard drive recovery . In the pop-up 'Edit Format Rules' dialog box, under 'Select the format of all cells determined by their respective values' choice, check 'Display information bar only' behind the format style; choose damaging values ​​and coordinate axis settings ;

Edit format rules

four. Within the pop-up 'Negative worth and coordinate axis settings' box, select the fill color, border colour, and coordinate axis settings that must be set, and click OK. Just after https://pastebin.fun/aX0rWXDpxv , click OK in the edit format rule box, then click OK inside the conditional format rule manager box.

Negative values ​​and coordinate axis settings

five. Soon after the Excel conditional format guidelines are set, the effect is presented.

Setup is complete

Ways to set the conditional formatting function in Excel shared these days to produce the comparison of good and negative values ​​of the information a lot more visual. The setting operation methods are very simple, I hope it will be helpful to all pals in their work!

Extra about Office-Excel operation expertise can join us to exchange learning together!