conditional formating

A

Allan

Using Excel, Is it possible to have a result in one cell apply conditional
formatting to adjacent cells?
 
F

Frank Kabel

Hi
yes it is :)
Try:
- select cell A1
- in the conditional format enter the formula
=$B$1="value"
- choose your format
 
Top