BarrattsMini
New Member
- Joined
- Mar 23, 2021
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
Hi all,
First post and I did try searching but couldn't seem to find what I was looking for.
I would like to have a row highlighted in red if blank which is easy enough. But, should any cell within that row have an entry I would like the row to no longer be highlighted.
The purpose here sits around when a particular case will be put forward for a meeting. Ideally every case in the spreadsheet would be aligned to a particular meeting, once a month, for review. Sometimes however we receive a case and the owner still has to flesh out the detail and isn't willing to commit to a particular month at that moment in time. I would like the row to be a certain color, say red, so I know to chase them for a date but once they do commit I'd like the row to no longer be formatted in red.
I hope this makes sense and thank you.
First post and I did try searching but couldn't seem to find what I was looking for.
I would like to have a row highlighted in red if blank which is easy enough. But, should any cell within that row have an entry I would like the row to no longer be highlighted.
The purpose here sits around when a particular case will be put forward for a meeting. Ideally every case in the spreadsheet would be aligned to a particular meeting, once a month, for review. Sometimes however we receive a case and the owner still has to flesh out the detail and isn't willing to commit to a particular month at that moment in time. I would like the row to be a certain color, say red, so I know to chase them for a date but once they do commit I'd like the row to no longer be formatted in red.
I hope this makes sense and thank you.