Hi i have a spread sheet or multiples where i need to format the cells bassed on percentage difference
MONTH 1 MONTH 2 MONTH 3 MONTH 4
A 100 100 200 100
b 100 100 150 175
c 100 150 170 180
d 100 100 200 220
e 100 100 180 150
See above - i need it to highlight red if the difference of previous month is more or less than 5%
Thanks Guys
Select all but your first column of data (i.e B2:E6 in this example).
Conditional Formatting> New Rule> Use Formula
=ABS(B2-C2)/B2>=5% format as red
If you're going to extend this conditional formatting beyond your data (i.e you have empty columns), use
=AND(ISNUMBER(C2),ABS(B2-C2)/B2>=5%)
Does that work for you?
See attachment
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You sir a a true super star - works a treat thank
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks