In my attached worksheet, can anyone tell me why in my conditional formatted rules, cells Y78:AM78 are shading green when there is no data entered in them? They should be shaded like the rest of the cells that don't have a value light blue.
Thanks!
In my attached worksheet, can anyone tell me why in my conditional formatted rules, cells Y78:AM78 are shading green when there is no data entered in them? They should be shaded like the rest of the cells that don't have a value light blue.
Thanks!
Not sure, but if you go over the cells with Delete, they do turn light blue.
There is a space [Char(32)] in the cells that's why it is showing green color, remove that spaces the color will disappear
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
from Y78:AM78
make it as 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks