I am creating a workbook in excel, that has multiple sheets. I have created the formula for getting what I want from 1 sheet to the next, but I am trying to add the conditional format to this and it is not working. I have 3 conditions that I need, 1) Cell value >6 becomes green 2) Cell value <1 becomes red 3) Cell value between 1 and 5 is yellow. I have added all the formats, but only the yellow and green are working. Can anyone help me.
Thanks
Tammy
Thanks
Tammy