Forum Discussion
conditional formatting
This seems to work (assuming I understood your conditions correctly). I've also attached the spreadsheet itself.
- how do i attach a excel?
how do i attach a excel?
You may not be able to. Those of us who've been around a while have that privilege granted to us, but since this is your first day....
BUT, what you can do and it's almost as effective, is put your Excel file on OneDrive or GoogleDrive and post a link to it here, making sure that you've granted access. Also don't post any confidential information in the sheet itself.
Mathetes,
You were a huge help, thank you.
With a little playing with what you posted I got it working.
this does the whole column when I highlight the whole column.
=AND((TODAY()-L2)>30,ISBLANK(M2))
Now I am trying to get the "L" column with no dates to be excluded.
