LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Conditional Formating based on multiple criteria

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating based on Date Flcnmech Excel Worksheet Functions 1 February 14th 08 08:21 PM
Conditional Formating based on a different cell Zsolt Szabó Excel Discussion (Misc queries) 2 December 9th 06 09:18 PM
Conditional formating based on text mango7 Excel Worksheet Functions 6 February 8th 06 10:11 PM
Set conditional formating for cell based on value in different cel D4137 Excel Discussion (Misc queries) 2 May 5th 05 08:15 PM
Conditional Formating based on another cell SMac Excel Discussion (Misc queries) 5 March 10th 05 07:17 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"