I have a sheet of percentages in columns where each cell is already populated with a formula. I want to format the font of each cell in a column based on whether it is greater or less than the previous cell, i.e. If B4>B3 make it green, if it's less make it red. Google has given me nothing but formatting based on fixed values, not 'whatever cell x contains' so am at a bit of a loss.
how versed are you with private sub like "selection change" or "change"? either one can be programmed to do that. For ad-hoc results please send a sample excel file
VBA is a bit over my head but I'd be happy to have a play if you gave me a start on the code. Attached is sanitised version of my workbook. Currently only 2 rows of data but this will increase week by week and current formatting was done manually. In essence just want cell colour to be green if the value is greater than the cell above it, or red if the value is less than the cell above it.
Book1.xlsx
Actually, I've found a solution by not being a chump and realising you can have multiple CF rules within the same cell.
The basic macro does the job for the data you sent.
Nevertheless, I noticed that there are more than 1 company reporting, so the marketshare sheet should refer only to one company?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks