conditional formating which reacts on nerby cells
 

Is it possible to change formating of values in column A depending on value
in column B ?

For example i want to highlight value entered in cell A1 in red if Cell B1
value is 1 and highlight in blue if B1 is 2

Select your cells, with A1 as the active cell. In the CF dialog, select formula, and use a formula

=B1=1

and set the format to red fill.

For the second condition, set the formula to

=B1=2

and set the format to blue fill.

HTH,
Bernie
MS Excel MVP


"Remote Desktop Connection hotkey" ft.com wrote
in message ...
Is it possible to change formating of values in column A depending on value
in column B ?

For example i want to highlight value entered in cell A1 in red if Cell B1
value is 1 and highlight in blue if B1 is 2