Conditional border formatting

  • Thread starter Thread starter twinspar
  • Start date Start date
T

twinspar

I need to apply a conditional format to rows (bottom line
solid)based on test of value in column A. If next value =
current value, do not format. Is there a way to
conditionally format the entire sheet to perform this
test? For example: A1=A2;apply format, A2=A3; apply
format, A3<>A4; do not apply, etc.
 
If you want the border applied if the value in column A doesn't match
the value in the cell below:

--Select all the cells that you want to format (e.g. A2:G500)
--Choose Format>Condtional Formatting
--From the first dropdown, choose Formula Is
--In the text box, type a formula that refers to the active row:
=$A2<>$A3
--Click Format, and on the Borders tab select the bottom border
--Click OK, click OK
 
Back
Top