 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-20-2008, 08:00 PM
|
|||
|
|||
|
equals
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 
|
|
05-20-2008, 08:11 PM
|
|||
|
|||
|
Re: equals
Hi Cindy
Highlight cell H3 Format>Conditional Formatting>use dropdown to select Formula Is> =G2=F3 >Format>Red>OK -- Regards Roger Govier "Cindy Conover" <cconover@kwnospamtrucklease.com> wrote in message news:1AC02A6A-35A2-4DD4-B23A-2AAEAEE5D754@microsoft.com... > 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
|
|
05-20-2008, 08:17 PM
|
|||
|
|||
|
Re: equals
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 On Tue, 20 May 2008 14:00:19 -0500, "Cindy Conover" <cconover@kwnospamtrucklease.com> wrote: >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
|
|
05-20-2008, 10:46 PM
|
|||
|
|||
|
Re: equals
Roger, Jordon, & Gord,
that is exactly what I wanted. Thank you so much. Keep up the great work! Cindy "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:bk8634t2gi3vainldt5cgtc31rtnqvk0k0@4ax.com... > 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 > > On Tue, 20 May 2008 14:00:19 -0500, "Cindy Conover" > <cconover@kwnospamtrucklease.com> wrote: > >>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 >
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
