Is there a formula what would automatically enter static number based on another cell color?
For example
if cell F9 is green then cell G9 will be always 12345678
if cell F10 is green then cell G10 will always be 12345678
Thanks
Is there a formula what would automatically enter static number based on another cell color?
For example
if cell F9 is green then cell G9 will be always 12345678
if cell F10 is green then cell G10 will always be 12345678
Thanks
Are the cells colored manually, through VBA, through conditional formatting?
What are the conditions inside "conditional formatting", see how is it possible to reused them in a formula.
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks