conditional formating which reacts on nerby cells

  • Thread starter Remote Desktop Connection hotkey
  • Start date
R

Remote Desktop Connection hotkey

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
 
B

Bernie Deitrick

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
 
Top