Highlight Negative And Positive Number In Excel
To Highlight The Negative And Positive Number Automatically In Excel Please Follow The Step & Images Shown Below.
SELECT THE RANGE
RIGHT CLICK >> GO TO FORMAT CELLS >> THEN GO TO CUSTOM FORMAT & PASTE THIS UNDER TYPE BOX :- [Green]#,##0.00;[Red]-#,##0.00
COPY-CUSTOM-CODE Download
NOW YOU WILL SEE THE GREEN FONT FOR POSITIVE NUMBER & RED FONT FOR NEGATIVE NUMBER.IF NOW YOU CHANGE ANY NUMBER AND IF IT IS NEGATIVE IT WILL CHANGE TO RED AND IF IT IS POSITIVE IT WILL CHANGE TO GREEN.NOTE: THIS ONLY WORK FOR THE SELECTION RANGE. SO PLEASE MAKE SURE TO SELECT THE RANGE PROPERLY OR SELECT THE WHOLE SHEET CELLS BEFORE APPLYING THE CUSTOM FORMAT.