Hi,

Can someone please advise on the following conditional formatting for a shift based spreadsheet:

I have a cell that calculate a range based on countifs, this is say B1 (will contain the formatting). Above this on A1 is the shift. Written as "7/5" ,"2/12" or "4/2".

I would like the condition to be that if the shift in A1 is "2/12" or "4/2" then B1 should be 2 or greater (become green for example) else if A1 is 7/5 B1 needs to be 1 or greater (become amber). Finally if the figure in B1 is 0 then (Turn red).

Any help would be greatly appreciated. Thank you in advance