Originally Posted by
almouchie
i have my sheet highlighted in different colors
I want to be able to format a row or a column except certain cells
is that possible
If not how can I write a code that says something like this
if column F=P then highlight cells F,G,H,I,J,K a certain color like yellow
& if cells in column B=1 then hightlight cells F,G,H,I,J,K a certain color like pink
if cells in column B=2 then hightlight cells F,G,H,I,J,K a certain color like blue
& so on
how can I start
any where would be great as record acro doesnt help really