I'm looking to make a cell chance color based on the value being greater or less than the cell before it in the column.
Red if value is less than
Green if greater then
I want to format this all the way down the column from 2-366
I can't figure out how to do it.thank you in advance.
Take a look at using Conditional Formatting. You will need a new rule for each condition
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
That's what I figured. I have the rules currently set off the start of each month. so it will go green or red based off that value from the first day of the month. was just hoping to avoid having to enter them all manually and could make it so each cell took the day before with out having to manually create 365 rules.
If you need to look at the day (row?) before, use cell refs instead.
in B3,,,
=B3<B2
format fill RED
etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks