How to grey out when numbers are entered manually so they look different than values got by formula?
If cell is colored manually (red square) it stay red.
How to grey out when numbers are entered manually so they look different than values got by formula?
If cell is colored manually (red square) it stay red.
Last edited by zbor; 05-09-2012 at 09:51 AM.
Hi zbor,
Please see attached if it suits your need.
Regards,
Bing.
EDIT: Please look into named ranges and conditional formatting in Sheet2
Last edited by quekbc; 10-21-2011 at 07:37 AM.
You can use a function to test if there is a formula and then Conditional Formatting
See the example
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe:
Please Login or Register to view this content.
quekbc: works great. ty
TMShucks: works too, but I think quekbc is faster
Kyle123: Sorry, it turns number to transparetn too... Maybe I miss something...
hmm, I'll have a look.
No need for me since problem is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks