Hello,
I have these two columns :
(F2 to L2) : 1. (Mon) 2. (Tue) 3. (Wed) 5. (Thu) 6. (Fri) 7. (Sat) 8. (Sun)
(F4 to L4) : .11-13 .6-14 .6-13 .7-15 .7-15 .7-15 .7-15
Question : IF SUM of number values exceeds =56 from Monday to Sunday, I want to highlight all number cells ( those which are SUM) with RED, or optional a Pop-up window like "You exceeded value ! ". Is It possible ?
thanks for your help !
Regards, Luka
I have these two columns :
(F2 to L2) : 1. (Mon) 2. (Tue) 3. (Wed) 5. (Thu) 6. (Fri) 7. (Sat) 8. (Sun)
(F4 to L4) : .11-13 .6-14 .6-13 .7-15 .7-15 .7-15 .7-15
Question : IF SUM of number values exceeds =56 from Monday to Sunday, I want to highlight all number cells ( those which are SUM) with RED, or optional a Pop-up window like "You exceeded value ! ". Is It possible ?
thanks for your help !
Regards, Luka