Conditional Formating based on multiple criteria

  • Thread starter Thread starter MikeD1224
  • Start date Start date
M

MikeD1224

Hi,

I have a spreadsheet with sales $ in Column I and a list date in column O.
I would like to apply conditional formatting to column O to highlight cells
whose date is 2007 or newer.

I would then like to apply conditional formatting to column I and highlight
cells whose sales $ are amongst the lowest 10% and who are not already
highlighted in Column O.

Is there a way to do a conditional formatting with an if formula and
accomplish this?

Thanks.
 
I have a spreadsheet with sales $ in Column I and a list date in column O.
I would like to apply conditional formatting to column O to highlight cells
whose date is 2007 or newer.
Click to expand...
Select column O and enter this formula in conditional formatting formula
field:
=YEAR(O1)>=2007
I would then like to apply to column I and highlight
cells whose sales $ are amongst the lowest 10% and who are not already
highlighted in Column O.
Click to expand...

Please specify in detail what do you call "amongst the lowest 10%". Whose
sales are less then 10% of total sales? Or something else?

Regards,
Stefi
 
Back
Top