conditional formating

[Guest]

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

 

[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.