View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Conditional Formatting Assistance

Select all the cells to check, starting with C2, and add CF with a formula
of

=$B2<C2

then set the highlight formatting.

--

HTH

Bob

"wendy" wrote in message
...
Hello,

I have a spreadsheet that contains multiple columns containing text. I
would like to highlight the unique values that exist in all other columns
when compared to the values of column B.

Any assistance in accomplishing this would be greatly appreciated.

Thanks