equals

  • Thread starter Thread starter Cindy Conover
  • Start date Start date
C

Cindy Conover

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
(e-mail address removed)
 
Hi Cindy

Highlight cell H3
Format>Conditional Formatting>use dropdown to select Formula Is> =G2=F3
 
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
 
Roger, Jordon, & Gord,

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


Cindy
 
Back
Top