Hello everyone, i am new to this so give me a little break.
What i am trying to do is use conditional formatting to make a cell a certain color based upon it being a number, that if the cell is older than today, and that another cell has an "X" in it. this is the formula i am using right now but i have 3 conditions.
First =IF($E$59:$E$75<TODAY(),$B59:$B75<>"X") Turn Cell Red
Second =IF(ISNUMBER($E59:$E75),$E59:$E75=TODAY()+7,$B59:$B75<>"X") Turn Cell Yellow When Within 7 Days Today.
Third =IF(ISNUMBER($E59:$E75),$E59:$E75<=TODAY(),$B59:$B75="X") Turn Cell Green
What im trying to accomplish is that when a cell with a date with in 7 days of today turns yellow as long as a different cell isnt "X". And i want it to turn green when a cell is at or behind the current date and has a "X" in it and turn red when a cell is at or behind the current date and dosent have an "X".