equals

R

Roger Govier

Hi Cindy

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

Gord Dibben

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
 
C

Cindy Conover

Roger, Jordon, & Gord,

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


Cindy
 
Top