Conditional Formatting In Absolute Number, Highlighted Color

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,524
hi all..

how to make CF formula with condition like this :
in absolute number (20% as parameter)

if C2=>20% - give this cell Red color
if C2=>-20% - give this cell Green color

data
expected result (Hightlighted)
25%
Red
-25%
Green

<tbody>
</tbody>

any help, greatly appreciated..

.sst
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Muhammad_Usman

Active Member
Joined
Dec 9, 2015
Messages
324
Its Quit Simple

After Selection you can put two criteria for Highlighted.

1)Select Equal or Greater Then option for 20%
2)Select Less or Equal then Option for -20%

Entered Cell Value to 20% and -20% Simultaneously.
Chose the Color which you want and apply this.

Hope you got it.
 
Last edited:

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
How do you enter -20% on a CF ?

You might have to use the "format only cells that contain" and use the between dropdown
and enter values of -0.2 and 0.2
 

Watch MrExcel Video

Forum statistics

Threads
1,089,755
Messages
5,410,241
Members
403,304
Latest member
shabsbingo

This Week's Hot Topics

Top