How do i apply conditional format to an empty cell?

tabitha shared this question 13 months ago
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.

Comments (1)

photo
1

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.

9f131d80e6cf5af4c65e65b306899728

baf619fa8d312fff1623e61a654bcaa8

Result will be

9c7c43f608a978797e8030d10d2ac889

Let me know how this goes and if this is what you are looking for.

Regards,

Paul

photo
1

that worked perfect! thank you

photo
1

Hi Tabitha,

Thats great to hear. Please let me know if you need anything else or are happy to close off this ticket.

Regards,

Paul

photo
1

Happy to close

photo
1

Thank you and have a great day.

Cheers,

photo