View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Conditional Formatting with Colours / Colors

It should work fine. Perhaps something might have gone astray in your
implementation. Try it again, here's some elaboration on the steps

Select the col headers "A" to "C"
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND($A1<"",OR(OFFSET($A1,1,)=$A1,OFFSET($A1,-1,)=$A1))
Click Format button Patterns tab Light brown? OK
Click OK at the main dialog

(Remember that row1 is presumed left empty)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...
This is not working. Do I need to put something in the "" or the <?