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

Hi

Mark the range of cells required in C and D
FormatConditional Formattingselect 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.
--
Regards

Roger Govier


"manoj" wrote in message
...
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