How do i apply conditional format to an empty cell?
Answered
I have a table of data and i want any cell that is empty to show as a colour. How can i do this please.
Files:
Empty cells.jpg
Hi Tabitha,
Yes you can do this. In 7.2 you need to change / setup conditional formatting for these cells as follows. This should be able to provide you with what you need.
Result will be
Let me know how this goes and if this is what you are looking for.
Regards,
Paul
Hi Tabitha,
Yes you can do this. In 7.2 you need to change / setup conditional formatting for these cells as follows. This should be able to provide you with what you need.
Result will be
Let me know how this goes and if this is what you are looking for.
Regards,
Paul
Replies have been locked on this page!