I realize that there have been numerous posts about this question and I have read through almost all of them, however, I cannot seem to get any of them to work. I will first admit that I know next to nothing about using macros with excel, but here is what I would like to accomplish.
Cell E5 is a value that must be entered manually and it must meet the following criteria, it must be a multiple of 6 and it must be >= to 54 and <= 192. That part is easy!
Now merged cells G5:M5 have the following formula,
=IF(AND(MOD(E5,6)=0,E5>=54,E5<=192),"WALL HEIGHT O.K.",IF(AND(MOD(E5,6)>0,E5>=54,E5<=192),"ERROR! WALL HEIGHT MUST BE IN 6" INCREMENTS!",IF(AND(MOD(E5,6)>=0,E5<54),"ERROR! WALL HEIGHT MUST BE 4'-6" MINIMUM","ERROR! WALL HEIGHT MUST BE 16'-0" MAXIMUM!")))
This formula works fine for the text, however the Big Boss Man would like it to have more of a visual impact if the person enters data that is not within the set parameters. I would like to be able to have the background be Green and not flash if the First IF statement is met "WALL HEIGHT O.K.", if either of the ERROR statements are met I would like to have the background flash Red, is this possible and if so could you be very explicit as to how to go about it. Thanks in advance for any help!
Cell E5 is a value that must be entered manually and it must meet the following criteria, it must be a multiple of 6 and it must be >= to 54 and <= 192. That part is easy!
Now merged cells G5:M5 have the following formula,
=IF(AND(MOD(E5,6)=0,E5>=54,E5<=192),"WALL HEIGHT O.K.",IF(AND(MOD(E5,6)>0,E5>=54,E5<=192),"ERROR! WALL HEIGHT MUST BE IN 6" INCREMENTS!",IF(AND(MOD(E5,6)>=0,E5<54),"ERROR! WALL HEIGHT MUST BE 4'-6" MINIMUM","ERROR! WALL HEIGHT MUST BE 16'-0" MAXIMUM!")))
This formula works fine for the text, however the Big Boss Man would like it to have more of a visual impact if the person enters data that is not within the set parameters. I would like to be able to have the background be Green and not flash if the First IF statement is met "WALL HEIGHT O.K.", if either of the ERROR statements are met I would like to have the background flash Red, is this possible and if so could you be very explicit as to how to go about it. Thanks in advance for any help!