K
Kim
Can someone give me the right formula to set condition for below
C D E F
3 In the Programme 5,110.39 1,217.39 40.76%
4 Not In Programme 20,079.87 0.00%
5 In the Programme 161,544.56 7,759.40 95.42%
The formula I've been using but it's not right
=AND($C3=""In the Programme,($F3<0.5))
What I want is if cell C = In the programme and cell F is less than 50%,
colour RED.
Example above, cell F3 should be in red.
Thanks.
C D E F
3 In the Programme 5,110.39 1,217.39 40.76%
4 Not In Programme 20,079.87 0.00%
5 In the Programme 161,544.56 7,759.40 95.42%
The formula I've been using but it's not right
=AND($C3=""In the Programme,($F3<0.5))
What I want is if cell C = In the programme and cell F is less than 50%,
colour RED.
Example above, cell F3 should be in red.
Thanks.