View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mwmasch mwmasch is offline
external usenet poster
 
Posts: 2
Default Formatting Rows of Data based on Column Data

I have tried this several times but it is not returning the results I need
here is more background.

The SS consists of rows of models that are available to sell so Column C &
D have the make & model that sales is looking for. the sheet is sorted by c&d
but they cant find it data quick enough. Multiple rows due to data in other
columns being differnt (serial#, dates etc.)

My thoughts were if C&D in the row# above are not 100% match change the
color of the row. I just cant execute this.
--
mwmasch


"mwmasch" wrote:

I have a SS with Column C Model # Column D Part # the other columns have
serial # etc. I want to highlight rows based exact match's to Columns C&D
only so sales people can quickly look and see if the Make and Model is in
stock. The sheet is getting long and even though I sort it by C&D the colors
would make it quick/easy to locate. Is this possible with Conditional
formatting?
--
mwmasch