Conditional Formatting VBA Help

[davidhall]

I need help with some conditional formatting with VBA.

I've been reviewing several post similar to what I need but don't know how to put the code together.


This is what I need.

I need the cells from rows B1 to B184 to have a clear fill color if they are blank.

Then I need any duplicate values in the same range of cells B1 to B184 to change to a green fill color.

Then I need any unique values in the same range of cells B1 to B184 to change to a light blue fill color.

Please help

 

[Marcelo Branco]

instead of right click on sheet name, press Alt + F11 that puts you into vb editor. Then click insert --> Module, now paste your code into that window.

Thanks (i was thinking i'm get crazy...)

M.

 

[Marcelo Branco]

David,

My bad...i'm using Excel 2007 in XP portuguese version
"=COUNTIF($B$1:$B$184;B1)>1"

Change the semi-colon to comma in both formulas

M.

 

[davidhall]

Now it is working properly. Thank you for your patience

 

[Marcelo Branco]

Now it is working properly. Thank you for your patience

You are welcome.

Glad that now its working

M.