View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Conditional formatting

Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!