equals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy Conover - 20 May 2008 20:00 GMT

I am really new at this, How would I write the formula - if G2 equals F3
turn H3 red.

Thanks

-
Cindy Conover
Truck Leasing Inc / PacLease
cconover@kwtrucklease.com

Reply to this Message

Roger Govier - 20 May 2008 20:11 GMT

Hi Cindy

Highlight cell H3
Format>Conditional Formatting>use dropdown to select Formula Is> =G2=F3

>Format>Red>OK

Signature

Regards
Roger Govier

> I am really new at this, How would I write the formula - if G2 equals F3
> turn H3 red.
[quoted text clipped - 5 lines]
> Truck Leasing Inc / PacLease
> cconover@kwtrucklease.com

Reply to this Message

Jordon - 20 May 2008 20:15 GMT

> I am really new at this, How would I write the formula - if G2 equals F3
> turn H3 red.

In H3 use conditional formatting using a formula that says
=if(g2=f3,true,false) and format it red.

Signature

Jordon

Reply to this Message

Gord Dibben - 20 May 2008 20:17 GMT

Select H3.

Format>Conditional Formatting>Formula is: =$G$2=$F$3

Format to nice red color.

Note: the $ signs will "fix" G2 and F3 as Absolute if that's what you want.

If you wanted to copy this to multi-cells, you may want different placement of
the $ signs.

Gord Dibben MS Excel MVP

>I am really new at this, How would I write the formula - if G2 equals F3
>turn H3 red.
[quoted text clipped - 5 lines]
>Truck Leasing Inc / PacLease
>cconover@kwtrucklease.com

Reply to this Message

Cindy Conover - 20 May 2008 22:46 GMT

Roger, Jordon, & Gord,

that is exactly what I wanted. Thank you so much. Keep up the great work!

Cindy

> Select H3.
>
[quoted text clipped - 20 lines]
>>Truck Leasing Inc / PacLease
>>cconover@kwtrucklease.com

Reply to this Message