Macro for coloring cells according to the value of the cell!
Closed
PeriGr
Posts
11
Registration date
Monday July 17, 2017
Status
Member
Last seen
August 12, 2017
-
Jul 20, 2017 at 11:39 AM
Blocked Profile - Jul 20, 2017 at 04:32 PM
Blocked Profile - Jul 20, 2017 at 04:32 PM
Hello,
I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment takes up a row. I want to compare values of F and G column between them and values of H and I column between them. If the difference is bigger than 0.5(from F and H values respectively) then I want the value of only(!) the cell G or/and I(the and is used just in case they are both 'guilty') to be red and then the whole row where this cell belongs(so the whole experiment) to appear in another sheet(but not the whole row be colored, just the cell I explained). And each time I add new experiments I want to be able to do the same process and for the values that are 'guilty' to appear the whole experiment in a new sheet(the whole row in the new sheet). But, additionally I want to have the ability to choose which experiments I want to check. Not check all experiments every time. Please help me with this you are going to save me !! If you can of course!
I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment takes up a row. I want to compare values of F and G column between them and values of H and I column between them. If the difference is bigger than 0.5(from F and H values respectively) then I want the value of only(!) the cell G or/and I(the and is used just in case they are both 'guilty') to be red and then the whole row where this cell belongs(so the whole experiment) to appear in another sheet(but not the whole row be colored, just the cell I explained). And each time I add new experiments I want to be able to do the same process and for the values that are 'guilty' to appear the whole experiment in a new sheet(the whole row in the new sheet). But, additionally I want to have the ability to choose which experiments I want to check. Not check all experiments every time. Please help me with this you are going to save me !! If you can of course!
Related:
- Macro for coloring cells according to the value of the cell!
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- How would you change all cells containing the word pass to green - Excel Forum
- Run macro when cell value changes by formula ✓ - Excel Forum
1 response
It is called Conditional Formatting, take a look here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color