View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cblanson@google.com is offline
external usenet poster
 
Posts: 2
Default Help formatting Column based on values in another column.

Hey,

I'm trying to have a value in column M strikethrough if the value in the same row but column F does not contain "xxxx".

Example:

Column M has dates and Column F has a status of an order.
If the status of cell in column F, is not "approved", I want the date in Column M to strikethrough...

..... is that possible?

Thanks in advance.