var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Can you format a cell so that if a persons name apears in a column and is put in again that cell goes red
Welcome to the Board!
Are you trying to prevent duplicate entries? If so, this may be of interest: http://support.microsoft.com/default...&Product=xlw2K
If duplicates are ok, but you just want them highlighted, select your data range and Goto Format-->Conditional Formatting-->Formula Is-->=COUNTIF($A$1:$A$33,A1)>1 Then select the Patterns Tab-->Red.
Where A1:A33 represents your range of data.
Hope that helps,
What you have described is what I am after.
The ranges are from A1:A204
I have done what you have discribed but it doesnt highlight them.
This if the formula I am using
Then Choose the colour to highlight if the same.
I am trying to highlight peoples names if they are duplicated.
I thank you for your help
Take no notice .........its working now
went back into the formula and it had put its self
so i changed it again
thanks for your halp again