Hi all,
Just another (hopefully) quick request.
I have a spreadsheet with 6 columns, each column months sales, A: Jan B: Feb etc. with each row representing a customer.
How can I apply a conditional format so that if Jan sales are less than Febs to highlight 1 colour, and a different colour for sales that are higher than previous month?
I can do this cell by cell, but with over 700 customers and 6 months to look at, it would take forever!
Thanks as always in advance.
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2<B2 format fill RED
repeat 3 and 4 with =A2>B2 format fill GREEN
This assumes that your data starts in row 2 - adjust as needed
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks