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

Assume A1:B1 will contain the inputs for model# and part#
with source col C = model# and col D = part# (as posted)

Select entire sheet, then apply the conditional formatting as
Formula is: =AND($C1=$A$1,$D1=$B$1)

An implemented illustration is available he
http://www.savefile.com/files/899021
Format entire rows using CF based on 2 input criteria.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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