Thread: Conditional formatting of adjacent cells based on text in cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_56_] daddylonglegs[_56_] is offline
external usenet poster
  
Posts: 1
Default Conditional formatting of adjacent cells based on text in cell

Select column A and use conditional formatting formula is option with
formula

=A1<B1

note this isn't case sensitive. If you want it to be

=NOT(EXACT(A1,B1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=569231

Reply With QuoteReply With Quote