I want the cells in the entire column to change color based on the column next to it.
For example if the cells in column N are less than Column O then I want N to change to red, if it is equal or greater by up to 10% I want them to be light green, if it is greater than 10% I want it to be light green.
Maybe this...
Conditional Formatting
- Highlight applicable range >> N2:N100
- Home Tab >> Styles >> Conditional Formatting
- New Rule >> Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =O2+(O2*0.1)
- Format… [Number, Font, Border, Fill] >> Green
- OK >> OK
Now add two more new rules:
=N2>O2+(O2*0.1) >> Light Green
=$N2<$O2 >> Red
In that order
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks