conditional formating

M

manoj

i have two colums C and D i want to highlight the cells in both colums where
the value is same in one row in both colums. means if C3=D3 it should be
highlited
 
R

Roger Govier

Hi

Mark the range of cells required in C and D
Format>Conditional Formatting>select Formula Is from dropdown> enter in
the formula pane =$C3=$D3
Form the Format dialogue, choose the format you want to use for either
Font colour or cell fill.
 
Top