View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Google Sheets - Help formatting Column based on values in another column.

Hey,

I'm working in Google sheets and 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.


My suggestion should work there as well, but you'll have to use their
feature[s] to do it if you want it to be native to GoogleSheets.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion