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.

Try rearranging thus:
=AND($C3="In the Programme",$F3<0.5)

"Kim" wrote:

> 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.
>
>
>
>
>

Assuming you are highlighting Column F, you need to start with F1...
=AND($C1="In the Programme",$F1<0.5)
--
------------
Hope This helps,
Sincerely,
Gary Brown



"Kim" wrote:

> 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.
>
>
>
>
>

Select the cells you want to apply color, in this case F3 and down
Format >> Conditional Formatting
Choose Formula Is under Condition 1
place this
=AND(C3="In the Programme",F3<50%)
Click on Format >> Pattern >> choose RED
OK out
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"Kim" wrote:

> 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.
>
>
>
>
>

Thanks. It's working now.

"Ron@Buy" wrote:

> Try rearranging thus:
> =AND($C3="In the Programme",$F3<0.5)
>
> "Kim" wrote:
>
> > 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.
> >
> >
> >
> >
> >

I selected the F Colum and use this for the conditional formatting formula:
=AND(C3="In the Programme", F3<50%)
F3 went red, as did F5 when I change its value to .4, and F4 when I change
C4 to "In the Programme"
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kim" <(E-Mail Removed)> wrote in message
news:F70FA962-D1F0-4622-A483-(E-Mail Removed)...
> 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.
>
>
>
>
>